If statement

[jrabi]

I have a spreadsheet:

Column A is the location
Column B is dollar sales
Column C is unit sales
Column D is % of dollar sales(b2/(sumB:B)
Column E is the accum of % of dollar sales
Column F I want to apply if E is greater than 0, less than 5, "A" if greater than 5, less than 25, "B", greater than 25, less than 50, "C", greater than 50, less than 75, "D", greater than 75, less than 100, "E".

Cant get started, have this formula:

=IF(E2>0,and IF(E2<=5,"A"))

Any help here and do I have to have the accum column or is there a formula that would sum the accum?

 

[Jonmo1]

Build a lookup table, and use a lookup formula..

Something like this

Excel Workbook
	E	F	G	H	I
1				Table
2	25	C		0	A
3	98	E		5	B
4	62	D		25	C
5	9	B		50	D
6	4	A		75	E
7	120	???>100		100	???>100
Sheet1

 

[jrabi]

Yes that would work, I hate lookup tables, someones always deleting them..........

 

[Jonmo1]

You can hard code the table into the formula...

Build it jast as I posted it, and write the formula as I posted it...

Then while in the formula, highlight the range H2:I7 and press F9
Whala!

 

[jrabi]

Want your lookup return an "A" for all.............

 

[jrabi]

0.00%A5.00%B25.00%C50.00%D75.00%E100.00%???>100

This works, thanks.

 

[T. Valko]

Yes that would work, I hate lookup tables, someones always deleting them..........

Well, that sucks!

Try it like this...

=IF(E2="","",IF(E2<5,"A",IF(E2<25,"B",IF(E2<50,"C",IF(E2<75,"D",IF(E2<100,"E",""))))))