LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
RJ
 
Posts: n/a
Default Add IF or Subtract IF??

I want to be able to Subtract 'change order'!G34 from 'team pay'!C35 & C36
only if it is a negitave and not to add to it if it is a positive. Not sure
if this is do-able but any help would be appericated.

Ray Byers Jr,
Northern Ca.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
subtract amounts from different columns? Paula Excel Discussion (Misc queries) 2 January 22nd 05 06:19 PM
how to subtract the very next LOWEST number maxkofe New Users to Excel 2 December 5th 04 06:06 PM
subtract a running balance from a SUM at the bottom of worksheet sam Excel Worksheet Functions 1 November 24th 04 12:43 AM
How can I subtract 111 from a number like 097 and get 987, using . Viper5963 Excel Worksheet Functions 6 November 8th 04 07:13 PM
how do you subtract military time? example 12:00 - 07:00 = 5 hour. Bill Excel Worksheet Functions 1 October 27th 04 08:25 PM


All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"