Hi

Your formula makes reference to its result, excel can't solve it,

you can use various if at the same formula

IF(conditional,action if is true, action if is false), so any action could
be another if

regards
Marcelo

"yairl" escreveu:


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