How do I...

P

petrino

I have a list of cells from B3:U3. I need to subtract that number by 410. How
do I do that?
 
D

David Biddulph

Firstly:
Subtract that number FROM 410, or subtract 410 FROM that number?
Secondly:
What number do you wish to subtract from 410. If it's the total of the
range B3:U3, and if you wish to subtract it FROM 410, then the formula is
=410-SUM(B3:U3).
 
P

Peo Sjoblom

Another option is to put 410 in an empty cell, format it the same way as
B3:U3, select it, copy it, then select B3:U3 and do edit>paste special
and select subtract.

Regards,

Peo Sjoblom
 
Top