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)
It may need more conditions...
- When the date in "R" is less then the date...in "F" and the date in "S" is greater then "F" it returns "33"
- When the date in "R" is greater then the date...in "F" and the date in "S" is less then "F" it returns "35"
- I get "N/A" if the both the dates in "R" and "S" are greater then "F"
- I get "33" if the both the dates in "R" and "S" are less then "F"