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
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)
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)
Related:
- Excell VALUE error
- Network error occurred - Guide
- Cmos checksum error - Guide
- Bios rom checksum error - Guide
- Error code 230000 - Video Forum
- Error code: 230000 ✓ - Internet & Social Networks Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 3, 2010 at 10:08 PM
May 3, 2010 at 10:08 PM
Most probably one of the cells in the formula is blank or has a text
