| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Function-formula help
Excel 2003
Question: How to write an if then formular to take the "0" out of the linked pages in the spreadsheet? Can anyone help me with this? Thank you. |
|
#2
|
|||
|
|||
|
Do you mean you have a formula like:
=sheet2!a1 that returns 0 when A1 on sheet2 is empty? if yes: =if(sheet2!a1="","",sheet2!a1) should work. "Robert M via OfficeKB.com" wrote: Excel 2003 Question: How to write an if then formular to take the "0" out of the linked pages in the spreadsheet? Can anyone help me with this? Thank you. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula within IF function | Excel Discussion (Misc queries) | |||
| use a formula as a cell reference in a function | Excel Worksheet Functions | |||
| Is there a formula, function or macro that accounts for shading of a cell or row? | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| function of "+" in the formula "=+(B19/50)*B10 | Excel Discussion (Misc queries) | |||
Linear Mode
