IF greater than...IF less than....======

B

BenJAMMIN

I am trying to figure out a simple formula but it is giving me fits:

If cell C3 is bigger than D3, Then take D3 and less the amount in F3 and
give me the sum
If cell D3 is bigger than C3, Then take C3 and less the amount in F3 and
give me the sum

So the formula needs to be a sum if statement???
What would it look like?
 
B

Biff

Hi!

Try this:

=IF(OR(C3="",D3="",F3=""),"",IF(C3>D3,D3-F3,IF(D3>C3,C3-F3,"equal")))

You haven't accounted for C3 and D3 being equal!

If any of the referenced cells are empty the formula will return blank ("").

Biff
 

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

conditional formatting if ANd 1
conditional formatting if and And 2
Looking to added up based on a character from cell range 1
SUMIF evaluating blank DATE data 2
Copy/Paste Formula-dropping 1st cell address 1
Formulas 3
Greater Less or Equal 3
Which formula will return a value for this table? 1

Top