Forum Discussion
Help with IF statement please - Much Appreciated
Yes, you can modify the formula to prioritize the owner with the "Waiting" state, even if both dates are empty. You can use the OR function to check if either the state or date is empty and then adjust the logic accordingly. Here's the modified formula:
=IF(AND(OR(ISBLANK(Table1[State]),Table1[State]<>"Waiting"),ISBLANK(Table1[Date])),"",IF(Table1[State]="Waiting","Bob","Dave"))
This formula checks if either the state or date is empty or if the state is not "Waiting" and the date is empty, in which case it returns an empty string. Otherwise, it returns "Bob" if the state is "Waiting" or "Dave" otherwise.
Yes, you can modify the formula to prioritize the owner with the "Waiting" state, even if both dates are empty. You can use the OR function to check if either the state or date is empty and then adjust the logic accordingly. Here's the modified formula:
=IF(AND(OR(ISBLANK(Table1[State]),Table1[State]<>"Waiting"),ISBLANK(Table1[Date])),"",IF(Table1[State]="Waiting","Bob","Dave"))
This formula checks if either the state or date is empty or if the state is not "Waiting" and the date is empty, in which case it returns an empty string. Otherwise, it returns "Bob" if the state is "Waiting" or "Dave" otherwise.
