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

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))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"David" wrote:
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

Dont worry.....

After tyoing it I worked out the formula

=IF(B39180,B39,180)


LOL

Glad to hear that!
No prob, I've whistled for the St Bernard to turn back with the whisky <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"David" wrote:
Dont worry.....
After toying it I worked out the formula
=IF(B39180,B39,180)
LOL