| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a cell amt AFTER IF equation
How do I complete a less than greater than equation,when the answer is true,
but having it go to another cell and copying that cell amount to where the formula is. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy a cell amt AFTER IF equation
On Mon, 20 Mar 2006 11:19:29 -0800, PatC
wrote: How do I complete a less than greater than equation,when the answer is true, but having it go to another cell and copying that cell amount to where the formula is. What do you want the formula to be when the answer is true? Generally =IF(Something<=SomethingElse,CellRef_WhenTrue,Cell Ref_WhenFalse) Substitute your Cell addresses for CellRef_WhenTrue & CellRef_WhenFalse HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| AUTOMATIC way to copy the value of a cell in one spreadsheet | Excel Worksheet Functions | |||
| how to count the number of text frequencies and copy to other cell | Excel Worksheet Functions | |||
| hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Hybrid Mode
