I get an error message '#value' with the following formula =1-(B3:C3) or
=(1)-(B3:C3).
any one know why this formula won't work? It's adding 2 percentages together and subtracting from 1, as in 1 - (20% + 20%) = 60%.
Thanks
I get an error message '#value' with the following formula =1-(B3:C3) or
=(1)-(B3:C3).
any one know why this formula won't work? It's adding 2 percentages together and subtracting from 1, as in 1 - (20% + 20%) = 60%.
Thanks
Last edited by frank142; 03-26-2009 at 02:11 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks