Thread: if value is greater than # * by 20% if less * by 40
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 2,118
Default if value is greater than # * by 20% if less * by 40
Try this:

For
A1: (a price)

The marked up price
B1: =A1*IF(A130,1.2,1.4)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"sypher" wrote:

if price is higher than 30 dollars markup by 20% if less than 30$ markup by 40%
Reply With QuoteReply With Quote