Excel help please
 

I need some help with Excel. I have a cell which contains a calculation, but I need it to default to a minimum value if the calculation does not generate enough

Here is the cell formula

But I need this to default to 500, if the values entered into cells E11 and E12 do not generate 500 as a result.

I tried searching Excel help, but to no avail.

Re: Excel help please
 

Do the calculation in a different cell ... then

use If ... then referencing that cell to check is it's lower than 500, if so set your cell to 500, if not use the cell you did the calculation in.

=IF(A1<500,500,A1)

A1 being the cell you did the calculation in

Re: Excel help please
 

I knew that someone would know - thanks for your prompt response

Re: Excel help please
 

Is there not a ceiling function in Excel?

Re: Excel help please
 

Or nest the calculation you want to do where the A1 is in the example so you would put the whole calculation inside brackets.

Re: Excel help please
 

TIP : If you put the intermediate cell (see Nem's example) in a separate row, you can then hide it completely

Re: Excel help please
 

You could do it in one fell swoop though :)
=IF((E11*0.00025)+(E12*0.0004)+(E11/52*0.025)+(E12/52*0.04)<500,500,A1)

Re: Excel help please
 

I knew that .... but as it looked complicated, I broke it down. The OP didn't seem too sure about formulas.

Re: Excel help please
 

I'm sure you did, I wasn't trying to devalue your answer :)