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