if statement

[Lizzi]

Hi,

Im using excel 2016, im trying to add i believe an if statement? into a cell but i dont know how to or if its the right statement to add

Col BP2:BP20446 contains revenue amounts (different amounts per row) i want column DS to have the result. so if BP2:BP20446 is <100K or between 100K & 250K or between 250K - 500K or >500K i want col DS to say <100K or >500K etc

does that make sense? hope so....

any help greatly appreciated
Thanku

 

[AhoyNC]

Re: if statement help please

Is this what you are looking for?
Change ranges to match your data and copy down as needed.

Excel Workbook
	A	B
1	Revenue
2	245,623	100K - 250K
3	130,824	100K - 250K
4	234,876	100K - 250K
5	279,328	250K - 500K
6	522,849	>500K
7	75,000
8	429,135	250K - 500K
9	535,125	>500K
10	119,189	100K - 250K
11	192,576	100K - 250K
12	490,458	250K - 500K
13	288,288	250K - 500K
Sheet

 

[Lizzi]

Re: if statement help please

Absolutely! thanku so very much

Is this what you are looking for?
Change ranges to match your data and copy down as needed.

	A	B
1	Revenue
2	245,623	100K - 250K
3	130,824	100K - 250K
4	234,876	100K - 250K
5	279,328	250K - 500K
6	522,849	>500K
7	75,000	<100K
8	429,135	250K - 500K
9	535,125	>500K
10	119,189	100K - 250K
11	192,576	100K - 250K
12	490,458	250K - 500K
13	288,288	250K - 500K

<colgroup><col style="width:30px; "><col style="width:81px;"><col style="width:102px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B2 =IF(A2<100000,"<100K",IF(A2<250000,"100K - 250K",IF(A2<500000,"250K - 500K",">500K"))) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[AhoyNC]

Re: if statement help please

You're welcome. Thanks for the feedback.