Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel spreadsheet
If one cell has a value no matter what the value is, i need to be able to
equale the value from another cell. Does anyone know what to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel spreadsheet
"gma" wrote:
If one cell has a value no matter what the value is, i need to be able to equale the value from another cell. Vague, but one thought Assume A1 is your "one cell" to monitor with B1 the other cell Then in say, C1: =IF(COUNTA(A1),B1,"") -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:62 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel spreadsheet
Hi,
If by "value" you mean a number then =IF(B5,B10,"") If you mean one cell, here B5, contains anything other than being blank, then =IF(B5<"",B10,"") where B10 contains the value you want to display if anything is in B5. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "gma" wrote: If one cell has a value no matter what the value is, i need to be able to equale the value from another cell. Does anyone know what to do this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel spreadsheet
Hi, thanks for the reply...i didnt make the question very clear. i have set
values in one colume and in the other colume the number changes... CELL A1 IS 500 CELL B2 IS THE FORMULA asking for the CELL C2 IS THE CHANGING VALUE say C3 gets a value from another range of cells, then i need B2 to recognize this, but input the set value from A1 can you help me with this? "ShaneDevenshire" wrote: Hi, If by "value" you mean a number then =IF(B5,B10,"") If you mean one cell, here B5, contains anything other than being blank, then =IF(B5<"",B10,"") where B10 contains the value you want to display if anything is in B5. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "gma" wrote: If one cell has a value no matter what the value is, i need to be able to equale the value from another cell. Does anyone know what to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Posting Excel spreadsheet to Google Spreadsheet using VBA | Excel Discussion (Misc queries) | |||
In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |