View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Excel ranges within a cell.

.. IF(A213<18
Try it like this: .. IF(AND(A213,A2<18)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Danny" wrote:
A2 is the numerical value < 13, or between 13 - 18, or 18. What formula do
I use? I tried =IF(A2<=13,"A",IF(A213<18,"B", IF(A218,"C"))). The only part
of the formula that doesn't work is it middle portion - IF(A213<18,"B".
Whataya think? Thanks so much.
Danny