less than greater than formula required

  • Thread starter Thread starter eksecretary
  • Start date Start date
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
 
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top