Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 questions about IF
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 questions about IF
"yairl" wrote in message ... 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? You are trying to store a value in B10, and put a formula in it as well. You can one or the other, not both. Use an extra column. 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? =IF(OR(A1=17,B1="No"),"yes","no") but why not nest them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm having trouble finding my posted questions? | Excel Discussion (Misc queries) | |||
Excel - how can I practice formulas on financial questions? | Excel Discussion (Misc queries) | |||
Questions concerning VBA coding | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Puzzling Format Questions | Excel Discussion (Misc queries) |