Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF greater than...IF less than....======
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? |
#2
|
|||
|
|||
Hi!
Try this: =IF(OR(C3="",D3="",F3=""),"",IF(C3D3,D3-F3,IF(D3C3,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 "BenJAMMIN" wrote in message ... 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? |
#3
|
|||
|
|||
One way:
=IF(COUNT(C3,D3,F3)=3,MIN(C3,D3)-F3,"") In article , BenJAMMIN wrote: 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? |
#4
|
|||
|
|||
How about:
=MIN(C3,D3)-F3 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "BenJAMMIN" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Less than, Greater than Formula | Excel Discussion (Misc queries) | |||
Help with SUMIF, INDEX, LOOKUP Please !! | Excel Worksheet Functions | |||
Help w/ SUMIF ; INDEX | Excel Worksheet Functions | |||
If Greater than when a formula Results in N/A | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |