How do I...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of cells from B3:U3. I need to subtract that number by 410. How
do I do that?
 
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).
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add extra function to formula 7
How to subtract a number from a Mergefield? 0
Can multiple criteria be used for IF formulas? 4
formula help 5
Change Format from Number to Percentage (sounds easy enough) 2
Count Cells Within 10 of a Cell Value 2
Need help with whichever is greater formula 3
LAST TIME, Adding in multiple numbers 6

Back
Top