Thread: if formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default if formula
Try this
=IF(A1<500,A1*1.5,A1*1.4)

"Dave" wrote:


--
Dave1125
Looking for formula for if less than $500.00 multiply by 1.5 but if over
$500.00 multiply by 1.4
Reply With QuoteReply With Quote