| 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 |
| 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) | |||
Threaded Mode
