Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
good day.
I need a formula for the following A B C D E F G H I 100 0 10 110 0 100 0 90 0 0 100 100 10 90 100 For column F, I need (if the total of C,D,E are bigger than A - B it should show A. For column G, I need (if the total of C,D,E are bigger than A - H it should show C,D,E - A For column H, I need (if the total of C,D,E are smaller than A - B it should give the total thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Plus or Minus | Excel Worksheet Functions | |||
Plus or Minus | Excel Discussion (Misc queries) | |||
How do you go one whole row minus another whole row | Charts and Charting in Excel | |||
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS | Excel Discussion (Misc queries) | |||
Value Minus Value = ??? | Excel Discussion (Misc queries) |