Thread: Can I add an IF statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
systemx
 
Posts: n/a
Default Can I add an IF statement

Try -

=IF(H9="Day",IF(Date=0,"",OFFSET(Data!$E$5,ROW(A1) +100,MATCH(G
8,Data!$F$3:$CT$3,0))),"What to do if H9 does not equal Day")

That should work.

You can 'nest' up to 7 IF statements in one formula - after that it can
get a little more complicated. :)

Regards,

Rob :)


--
systemx
------------------------------------------------------------------------
systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254
View this thread: http://www.excelforum.com/showthread...hreadid=539484

Reply With QuoteReply With Quote