New to this ! If Cell = less than

D

David

Hi,

I am new to all this and I am having trouble with a function.

I am doing a quote system for a friend and need to get his day rate to
be at least £180

To work out the day rate I am using his hourly * the hours.

But I would like to be able to get it to say if cell A30 = less than
£180 then make cell A31 £180

I know this is possible just cannot work out the formula

Thanks in advance


David
 
M

Max

One way ..
Assuming the hours worked will be entered in A30, and wage rate = 25 per hour
Put in A31:
=IF(A30="","",MAX(180,A30*25))
 
M

Max

Glad to hear that!
No prob, I've whistled for the St Bernard to turn back with the whisky <g>
 
Top