| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
having problems equaling other cells with values
Ok my problem is I need to equale or copy a number/value from one cell and
put it into another cell that has the "formula", but only if the cell in question gets a number/value from a range of cells. Let me try and put it like this also: Cell A1 is "500" and is the Cell B2 is the cell and formula that I want the number from "colume A" to go to but only if, Cell C3 gets a value other than "0" from another range of cells, then i need B2 to recognize this, and input the set value from A1 into B2 can anyone help me with this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
having problems equaling other cells with values
Put this in B2
=IF(C3<0,A1,"") This will put the value from A1 in B2 only if C3 is not zero, otherwise it will leave B2 empty... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "gma" wrote: Ok my problem is I need to equale or copy a number/value from one cell and put it into another cell that has the "formula", but only if the cell in question gets a number/value from a range of cells. Let me try and put it like this also: Cell A1 is "500" and is the Cell B2 is the cell and formula that I want the number from "colume A" to go to but only if, Cell C3 gets a value other than "0" from another range of cells, then i need B2 to recognize this, and input the set value from A1 into B2 can anyone help me with this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
having problems equaling other cells with values
It worked...thanks a bunch.
"Sheeloo" wrote: Put this in B2 =IF(C3<0,A1,"") This will put the value from A1 in B2 only if C3 is not zero, otherwise it will leave B2 empty... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "gma" wrote: Ok my problem is I need to equale or copy a number/value from one cell and put it into another cell that has the "formula", but only if the cell in question gets a number/value from a range of cells. Let me try and put it like this also: Cell A1 is "500" and is the Cell B2 is the cell and formula that I want the number from "colume A" to go to but only if, Cell C3 gets a value other than "0" from another range of cells, then i need B2 to recognize this, and input the set value from A1 into B2 can anyone help me with this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| =LARGE and cells equaling 0 | Excel Discussion (Misc queries) | |||
| Problems appending cells together | Excel Worksheet Functions | |||
| Problems with Text values in Excel. | Excel Discussion (Misc queries) | |||
| go to cell with date equaling TODAY() | Excel Discussion (Misc queries) | |||
Linear Mode
