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))
C46 would only contain a number. E18 is the only cell that could possibly have text.
But there is no arithmetic operation with E18.