I need to do a arithmetic if than formula
 

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.

I need to do a arithmetic if than formula
 

=max(50,yourcalculation)

may work ok.

Tony wrote:

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

I need to do a arithmetic if than formula
 

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.


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

I need to do a arithmetic if than formula
 

=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.



Tony wrote:

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.

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


--

Dave Peterson