New to this ! If Cell = less than

[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

 

[Guest]

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))

 

[David]

Dont worry.....

After tyoing it I worked out the formula

=IF(B39>180,B39,180)


LOL

 

[Guest]

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