Excell VALUE error [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Would you be so kind as to evaluate the formula and see what I did wrong. It returns a VALUE error. I tried the evaluator, but im not clear where the problem lies.

Thanks
Todd

=IF(B10+C10<=16.7,(16.7*0.6)*328,IF(B10<=10.02,(10.02*328),IF((AND(B10>=10.03,C10<=6.68)),(E10-16.7)*325+F19))),IF((AND(B10>=10.03,C10>=6.69)),B10*328)

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
Most probably one of the cells in the formula is blank or has a text

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!