Greater than & Less than

G

Guest

Can anyone tell me how to put this statement into a formula
If cell value of d4 is <4 than put in the put in the cell value from D2
if the cell value of d4 is >4 but <10 then put in the cell value from D2
if the cell value of d4 is >10 but <20 then put in the cell value from D2

eg; if D4 =18 then it would put the answer of cell D2
if D4 =9 the it would put the cell value of D2
 
N

Norman Harker

Hi Mike E!

Try:
=IF(D4<4,D26,IF(D4<10,D27,IF(D4<20,D28,"20 or over")))

But this returns D26 if D4 is empty so the following might be better:

=IF(D4="","",IF(D4<4,D26,IF(D4<10,D27,IF(D4<20,D28,"20 or over"))))

--
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top