I need to do a arithmetic if than formula

[Guest]

All excell with give me true and false.

I need to calculate a value vased on two cells. If the end value is 49 or
less I need to have default to 50.

 

[Dave Peterson]

=max(50,yourcalculation)

may work ok.

All excell with give me true and false.

I need to calculate a value vased on two cells. If the end value is 49 or
less I need to have default to 50.

 

[Guest]

Here is what I am attempting to do in excel.

=SUM(F41-E41) "if VALUE is less than F45 then use the value in F45"

FYI F45 is an input value can can be any number.

 

[Dave Peterson]

=max(F45, f41-e41)

Maybe???

ps.

In your original formula, =sum(f41-e41), you don't need the =sum() portion.
Just F41-E41 would be sufficient.