Thread: New to this ! If Cell = less than
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default New to this ! If Cell = less than
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


Reply With QuoteReply With Quote