IFs and ORs
Replace "ERROR" by "" to get a blank if none of the conditions are met...
"DavidT" wrote:
Your solution worked great once I cleared out "ERROR". What I forgot to ask
is now if there is no data for the solution, I get a return of "FALSE" but
would prefer to have an empty cell indicated. I've tried to incorporate ""
into D5, but can't get to work.
"Sheeloo" wrote:
=IF(AND(D1=2,D3<14),0,IF(AND(D1=2,D3=14),D3-14*F1,IF(AND(D1=3,D3<16),0,IF(AND(D1=3,D3=16),D3-16*F1,IF(AND(D1=4,D3<17),0,IF(AND(D1=4,D3=17),D3-17*F1,"ERROR"))))))
Seems to be Ok.
Note that I have added equality condition also...
"DavidT" wrote:
Tried every combination I could think of, here's what I need for for a
solution for ONE cell:
If D1=2 and D3 is <14 then D5=0 , If D1=2 and D3 is 14 then D3-14*F1 OR
If D1=3 and D3 is <16 then D5=0 , If D1=3 and D3 is 16 then D3-16*F1 OR
If D1=4 and D3 is <17 then D5=0 , If D1=4 and D3 is 17 then D3-17*F1
How can I get this into a single formula for an answer in one cell?
|