Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to do 2 calculations in 1 cell
I have the following calculation
=IF(F7="","",(F7+H7)):=IF(D7="" ,"",(J6+Template!T29)) I am trying to get ith that I have a vaulue in on Columnb it will add it but if I have it a number in another column it wil subtract it. Thanks -- N/A |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to do 2 calculations in 1 cell
You need to be clearer with your question. Your conditions seem to have 2
cells which you are testing for being empty. You therefore have 4 possible combinations. What answer do you want in each of the following 4 cases? D7="" and F7="" D7 ="" and F7<"" D7<"" and F7="" D7<"" and F7<"" -- David Biddulph "Joel" wrote in message ... I have the following calculation =IF(F7="","",(F7+H7)):=IF(D7="" ,"",(J6+Template!T29)) I am trying to get ith that I have a vaulue in on Columnb it will add it but if I have it a number in another column it wil subtract it. Thanks -- N/A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Cell Calculations | Excel Discussion (Misc queries) | |||
Cell doesn't update automatically even when Calculations are on Au | Excel Discussion (Misc queries) | |||
Calculations based on cell value | Excel Worksheet Functions | |||
Maximum Value of a Cell over a series of calculations | Excel Discussion (Misc queries) | |||
Cell Calculations | Excel Worksheet Functions |