Greater than & Less than

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top