| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get excel to display blank if reference cell blank
I'm trying to get a blank if a refernce cell is blank or perform calculation
using the reference cell if there is an entry in the ref cell |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to get excel to display blank if reference cell blank
=IF(Sheet1!A1="","",Sheet1!A1*250)
as an example -- Regards, Peo Sjoblom "silent1 (not)" wrote in message ... I'm trying to get a blank if a refernce cell is blank or perform calculation using the reference cell if there is an entry in the ref cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Enter an Excel cell reference as part of a custom header/footer | Excel Worksheet Functions | |||
| Excel should have a absolute reference cell property. | Excel Discussion (Misc queries) | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
Linear Mode
