IF Statement Question

[DMcCallister]

Just curious if there is a way to reduce the length of my excel formulas that are similar to the following example...

=CEILING(IF(((S6*X47+R48-S56)+(S17*X51+R52-S60))*0.15>20000,20000,((S6*X47+R48-S56)+(S17*X51+R52-S60))*0.15),1000)

So in essence is there a way to avoid having to rewrite the ELSE which is the same as the Logical Test.

 

[Joe4]

Can you explain exactly what you want your formula to do?

 

[DMcCallister]

I was just wondering if there was a quick way to take the result of the Logical Test and make that the value of the cell with out having to repeat the logical test again, as the Else statement.

So Basically...

Function for Rounding
=CEILING(

Logic Test
IF(((S6*X47+R48-S56)+(S17*X51+R52-S60))*0.15>20000

IF True
,20000

IF False (This is the same as the Logic Test)
,((S6*X47+R48-S56)+(S17*X51+R52-S60))*0.15)

Rounds up to the Thousand
,1000)

I'm just seeing if there is a way to default the cell to the Logic Test value if it is not True since it's basically doing the calculation twice.
Hope that helps.

 

[Joe4]

How about:

=CEILING(MIN(((S6*X47+R48-S56)+(S17*X51+R52-S60))*0.15,20000),1000)

I just replaced your IF function with a MIN function, telling it to take the lesser of your calculation and 2000.

 

[DMcCallister]

lol Wow thanks for making me feel stupid this early in my day :P

 

[Joe4]

We have all been there at one time or another. Sometimes we can't see the forest for the trees and needlessly complicate something!