Subtracting
 

I need to subract B3 through U3 from 410. I can't figure out how to do it.

Thanx

Subtracting
 

In article ,
says...
I need to subract B3 through U3 from 410. I can't figure out how to do it.

Thanx

Suppose you want the result in B4:U4. Then, in B4 enter =410-B3. Copy B4
to C4:U4.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Subtracting
 

You can do the following:

Enter the formula =sum(B3:U3) in a empty cell say B14
Then substarct =B14-410, B14 is total sum of B3:U3

Challa Prabhu

"Tushar Mehta" wrote:

In article ,
says...
I need to subract B3 through U3 from 410. I can't figure out how to do it.

Thanx

Suppose you want the result in B4:U4. Then, in B4 enter =410-B3. Copy B4
to C4:U4.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions