| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i use 'if' command to display answer in different cell?
I'm doing a tick sheet type spreadsheet.
I want to hide the formula in one cell check for a true or false with the IF command and display in a different cell. I can get it to display in formula sell, but because of the amount of different varriables in the tick sheet i cant just put the formula in the answer cell. i' looking for something like this: =IF(D3="x",4.34,1) so if D3 had a x in it, the formula cell would show 4.34, otherwise 1. this works but i want to display answer in another cell. i thought this would work but it does not : =IF(D3="x",AA3=4.34,1) so answer would be displayed in AA3. Can anyone help, thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display a drop-down list based on the content of another cell | Excel Discussion (Misc queries) | |||
| Display text 1024 characters in a cell | Excel Worksheet Functions | |||
| display contents of cell | Excel Discussion (Misc queries) | |||
| Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
Threaded Mode
