LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Hiding Formulas

Looking for formula set up help. Current workbook I have for example,
information in cell A1 from sheet one formulated to sheet 2 for same cell as
='Sheet1'!A1+2 If no info is entered on sheet one in cell A1 the info on
sheet 2 for cell A1 just shows 2.00 as it should. What I want to be able to
do, is if nothing is entered on say Cell A1 of sheet one, that instead of
showing the 2.00 on sheet to it either shows a 0 or shows nothing at all.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding formulas ps139 Excel Discussion (Misc queries) 3 July 29th 08 05:48 PM
HIDING FORMULAS zen Excel Discussion (Misc queries) 3 July 1st 08 09:25 PM
Hiding Formulas Wins07 Excel Discussion (Misc queries) 2 April 2nd 07 10:34 PM
Hiding Formulas EG Excel Worksheet Functions 3 November 15th 06 05:24 PM
Hiding formulas Donald Excel Discussion (Misc queries) 5 December 14th 05 10:32 PM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"