Forum Discussion
erin-5304
Mar 30, 2023Brass Contributor
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 answer will be decided using 2 different cells of information, E18 and C46. Any ideas?