If condition formula required
Solved/Closed
Related:
- If condition formula required
- Conditional formula ✓ - Forum - Office Software
- Excel conditional formatting formula if cell contains text ✓ - Forum - Excel
- Excel vba conditional formatting formula multiple conditions ✓ - Forum - Excel
- Excel formula to change font color with conditional formatting ✓ - Forum - Excel
- Excel conditional formatting formula based on another column ✓ - Forum - Excel
1 reply
Mazzaropi
Jun 12, 2015 at 05:43 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Jun 12, 2015 at 05:43 PM
Raghuram, Good evening.
Try to use:
=IF(AB2=0,0,IF(AB2>=5,V6-150,IF(AB2>=4,V6-120,IF(AB2>=3,V6-89,IF(AB2>=2,V6-59,V6-28)))))
Is it what you want?
I hope it helps.
Try to use:
=IF(AB2=0,0,IF(AB2>=5,V6-150,IF(AB2>=4,V6-120,IF(AB2>=3,V6-89,IF(AB2>=2,V6-59,V6-28)))))
Is it what you want?
I hope it helps.
Jun 14, 2015 at 04:04 AM