| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use IF to change value in a different cell when TRUE (or FALSE)?
I'd like to do the following:
=IF(A1=10, B1="Right", "Left") If not IF, then how? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use IF to change value in a different cell when TRUE (or FALSE)?
Formula results show up in the cell where the formula is located. BUT, they
can (and usually do) take other cells as inputs. So put the formula in cell B1 (where you want the result): =if(a1=10,"Right","Left") "Ricter" wrote: I'd like to do the following: =IF(A1=10, B1="Right", "Left") If not IF, then how? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use IF to change value in a different cell when TRUE (or FALSE
Well, unfortunately, if I put the formula in B1, then I'll want it to change
the value of cell C1 if A1=x... Sounds like it can't be done, at least not with IF. "bpeltzer" wrote: Formula results show up in the cell where the formula is located. BUT, they can (and usually do) take other cells as inputs. So put the formula in cell B1 (where you want the result): =if(a1=10,"Right","Left") "Ricter" wrote: I'd like to do the following: =IF(A1=10, B1="Right", "Left") If not IF, then how? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shorten a Macro | Excel Discussion (Misc queries) | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| SQL - Auto Refresh Upon Cell Value Change | Excel Worksheet Functions | |||
| How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Linear Mode
