error in simple formula

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

Try this:

Please Login or Register  to view this content.