If Question

Closed
viking57 - Apr 15, 2010 at 05:19 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 15, 2010 at 06:05 PM
I have the following formula that works in older excel, but when I use it in 2007 it give me a #value! error, but formula works=IF((C18-D18-E18-F18)=0,"",(C18-D18-E18-F18)) what's wrong?

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 15, 2010 at 06:05 PM
At least one of the cells listed has a non-numeric character
0