how to do 2 calculations in 1 cell

J

Joel

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
 
D

David Biddulph

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<>""
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate plus or minus 0
If then Else statement 0
If calcv 0
Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result 1
If condition to find Target 1
calculate time elapsed inbetween days 3
Need help with formula 10
Summing data based on a seperate column 4

Top