Excell if equations
Closed
mike
-
Apr 15, 2010 at 07:54 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 15, 2010 at 08:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 15, 2010 at 08:49 PM
Related:
- Excell if equations
- Excel if statement - Guide
- How many nested if statements in excel - Guide
- Excel vba check if value exists in list - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel vba create folder if not exist ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 15, 2010 at 08:49 PM
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)))
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)))
