less than greater than formula required

E

eksecretary

Hello

I would like some help with a formula I require to speed up my analysi
of areas.

A B C D E F
Colums

Length Breadth Area M2 <50 50-500 >500 Headings

5 5 25 25 - -

25 25 625 625

20 20 400 400

I would like the areas to appear in categories <50, 50-500 and >500 bu
I do not know the formula require.

Please help as this would speed up my workload.

Thanks

Regards

Jennifer
E K Secretar
 
F

Frank Kabel

Hi
try the following:
D2: =IF(C2<50,C2,"")
E2: =IF(AND(C2>=50,C2<=500),C2,"")
F2: =IF(C2>500,C2,"")
copy this down
 
N

Norman Harker

Hi eksecretary!

Three formulas
Assuming first data is in Row 2
D2:
=IF(C2<50,C2,"")
E2:
=IF(AND(C2>=50,C2<=500),C2,"")
F2:
=IF(C2>500,C2,"")

You can copy these down.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top