Cable Forum - View Single Post

Janusian · 19-04-2005, 10:06

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

Code:

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

19-04-2005, 10:06	#1
Janusian Inactive Join Date: Jul 2004 Age: 53 Posts: 91	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 Code: =(E110.00025)+(E120.0004)+(E11/520.025)+(E12/520.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.