| Home |
| Search |
| Today's Posts |
|
#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? |
| 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
