If Formula
Closed
Azhar
-
24 Jan 2011 à 01:16
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 24 Jan 2011 à 22:39
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 24 Jan 2011 à 22:39
Related:
- If Formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
- Credit summation formula - Guide
- Formula to calculate vat in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
24 Jan 2011 à 22:39
24 Jan 2011 à 22:39
suppose you enter client number in A2 the
in B2 tyhpe or copy this formula
=IF(AND(A2>=0,A2<=7),0,IF(AND(A2>7,A2<=14),3000,IF(AND(A2>14,A2<=20),6000,IF(AND(A2>20,A2<=30),9000,IF(A2>30,12000,"")))))
in B2 tyhpe or copy this formula
=IF(AND(A2>=0,A2<=7),0,IF(AND(A2>7,A2<=14),3000,IF(AND(A2>14,A2<=20),6000,IF(AND(A2>20,A2<=30),9000,IF(A2>30,12000,"")))))
