View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default How do I do a multiple IF

I'm not clear on what you want, but the syntax for nested IF statements is
the following:

=IF(A,B,IF(C,D,IF(E,F,G)))
--
Brevity is the soul of wit.


"Sean" wrote:

How do I automatically enter the data on condition of another cell:
If type 1 then old NO
If type 2 then New NO
If type 3 then New NO
If type 4 Then Old NO

where New No Column a
and Old NO column B
Type is Column C
date req in column d

mUCH APPRICATIED IF ANYONE CAN HELP WITH FORMULAR