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
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
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
