Thread: if formula
View Single Post
  #2   Report Post  
Les Linton Les Linton is offline
Junior Member
  
Posts: 13
Default
Quote:
Originally Posted by Dave View Post
--
Dave1125
Looking for formula for if less than $500.00 multiply by 1.5 but if over
$500.00 multiply by 1.4
=IF(A1<500,(A1*1.5),(A1*1.4))

Les
Reply With QuoteReply With Quote