Excel help please

[Janusian]

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

 =(E11*0.00025)+(E12*0.0004)+(E11/52*0.025)+(E12/52*0.04)

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.

[Nemesis]

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

[Janusian]

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

[philip.j.fry]

Is there not a ceiling function in Excel?

[SMHarman]

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

[MetaWraith]

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

[PC_Arcade]

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)

[Nemesis]

Originally Posted by PC_Arcade

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)

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

[PC_Arcade]

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