Help with excel IF formula
Closed
kirstybill
-
Oct 8, 2009 at 08:33 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 8, 2009 at 10:38 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 8, 2009 at 10:38 PM
Related:
- Help with excel IF formula
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel free download - Download - Spreadsheets
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 8, 2009 at 10:38 PM
Oct 8, 2009 at 10:38 PM
=IF(AND(C2>=0.01,C2<=0.99),0,IF(AND(C2>=1,C2<=4.99),0.15,IF(AND(C2>=5,C2<=14.99),0.25,IF(AND(C2>=15,C2<=29.99),0.5,IF(AND(C2>=30,C2<=99.99),1,IF(C1>100,1.3,0))))))
It is a long formula. study this formula with "and"s, brackets etc you can crate your own formula next time.
there are six ifs. in versions before excel 2007 there can be only maximum of seven ifs
It is a long formula. study this formula with "and"s, brackets etc you can crate your own formula next time.
there are six ifs. in versions before excel 2007 there can be only maximum of seven ifs
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Oct 8, 2009 at 01:34 PM
Oct 8, 2009 at 01:34 PM
do a search on google for nested if statements in excel
