If condition formula required
Solved/Closed
Related:
- If condition formula required
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 12, 2015 at 05:43 PM
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