Forum Discussion
Solved
Improving IF formula
Hello guys, is it possible to write this formula in a simpler way? I use it in a spreadsheet multiple times in multiple Sheets and from time to time I get the error: Excel ran out of resources (o...
Stay with your original formula.
This appears to produce the same result:
=IF(E5>0,IF(OR($C$5=DATE!$C$3:$E$3),0,IF(AND($C$5>=DATE!$B$3,$C$5<DATE!$F$3),E5,F5)),F5)
thank you for your reply! this is very good but there is only one rule that is missing:
From my initial formula, second row:
IF(AND(E5>=0,$C$5>=DATE!$C$3,$C$5<DATE!$D$3,$C$5=DATE!$C$3),0,
Can you please take a look? I tried a few combinations but it returns FALSE instead of 0. It is beyond my understanding...
I attach the excel file.
Here is the scenario:
DATE sheet:
MODEL sheet:
If today's date is = to DATE 1,2,3,4 or 5 and cell E5 = 0 , and F5 > 0, the end result must be 0 , not 50
Thank you very much
Alecs
Stay with your original formula.
- Managed to do it by adding the condition in front. Now all is oki 🙂
Thanks a lot for all the help provided! I will replace this formula in my entire workbook
=IF(AND(E5>=0,OR($C$5=DATE!$C$3,$C$5=DATE!$D$3,$C$5=DATE!$E$3,$C$5=DATE!$F$3)),0,IF(E5>0,IF(OR($C$5=DATE!$C$3:$E$3),0,IF(AND($C$5>=DATE!$B$3,$C$5<DATE!$F$3),E5,F5)),F5))
