Excell if equations

Closed
mike - Apr 15, 2010 at 07:54 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Apr 15, 2010 at 08:49 PM
if product x is > 15 then multiply by 3, if x is < 15 but > than 5 then multiply by 2 and if x is < of 5 then multiply by 1.5

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Apr 15, 2010 at 08:49 PM
Dont know where and how x is coming

lets say x is the value is cell A1 then in B1 you can have

=A1 * (IF(a1 > 15, 3, IF(a1 >5, 2, 1.5)))
0