Forum Discussion
Solved
IF Formula / #Value! Error
Having trouble figuring out what is causing the #Value! error in the following formula: =IF(E18="Flat Rate",IF(C46>360,SUM(C46/2-150)*8),IF(E18>=0.01,IF(C46>300,SUM(C46/2-150)*8),"") The answ...
Try
=IF(E18="Flat Rate",IF(C46>360,(C46/2-150)*8,0),IF(E18>=0.01,IF(C46>300,(C46/2-150)*8,0),0))
Try
=IF(E18="Flat Rate",IF(C46>360,(C46/2-150)*8,0),IF(E18>=0.01,IF(C46>300,(C46/2-150)*8,0),0))
I guess with "abc" in E18 result will be incorrect.
You're correct.