ExcelBanter - if value is greater than # * by 20% if less * by 40

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - if value is greater than # * by 20% if less * by 40 (https://www.excelbanter.com/new-users-excel/118162-if-value-greater-than-%2A-20%25-if-less-%2A-40-a.html)

sypher

if value is greater than # * by 20% if less * by 40

if price is higher than 30 dollars markup by 20% if less than 30$ markup by 40%

Ron Coderre

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%

All times are GMT +1. The time now is 03:04 PM.