Help with excel IF formula
Closed
kirstybill
-
8 Oct 2009 à 08:33
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 8 Oct 2009 à 22:38
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 8 Oct 2009 à 22:38
Related:
- Help with excel IF formula
- Grade formula in excel marksheet - Guide
- Formula to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
8 Oct 2009 à 22:38
8 Oct 2009 à 22:38
=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 23 May 2009
Status
Contributor
Last seen
20 October 2010
183
8 Oct 2009 à 13:34
8 Oct 2009 à 13:34
do a search on google for nested if statements in excel
