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

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