Forum Discussion
Solved
IFS does not return correct results
I am using the following formula: =IFS(F7>=$R$1,33,F7>$S$1,35,F7="",0) The formula is returning the first condition and the last condition but not the second condition. FYI, F7 contains a date (an...
Hard to say without knowing what the cells contain.
Does this do what you want?
=IFS(F7>=$S$1,35,F7>$R$1,33,F7="",0)
Thanks Sergei and Hans as both of these formulas provide the results I have been looking for!