View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yairl
 
Posts: n/a
Default 2 questions about IF


Hey guys,
I've been working in the last few hours on an excel form for work, and
I have 2 questions about operations I don't know how to perform:

1. This is the command i have in cell B10:
IF(b2=$b$6,b10+1)
I just want to add 1 to B10 if the condition fulfills. It doesn't work
- do you know why?

2. I need to combine 2 different IF commands into one cell (I can't and
don't want to combine them into one nested IF). is it possible?

Thanks ahead.


--
yairl
------------------------------------------------------------------------
yairl's Profile: http://www.excelforum.com/member.php...o&userid=34953
View this thread: http://www.excelforum.com/showthread...hreadid=546866