Previous Topic Next Topic

Excell VALUE error

Closed
todd - May 3, 2010 at 09:50 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 3, 2010 at 10:08 PM
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 3, 2010 at 10:08 PM
Most probably one of the cells in the formula is blank or has a text
0

Similar discussions

Corel Draw: Error Reading file problem
clinton_fields2 -
clinton_fields2 -

2 responses
ps3 error problem 80023017 how can i fix it
siendy -
Bobstew -

2 responses
Instagram caption issue
giddensg -
Rw -

7 responses
error code 230000
Rajvir -
dwebb -

1 response
How to fix error code
Sally -
Sally -

4 responses