its easier if i give u an example
i got 2 sheets in excel Sheet1 and Sheet2. i go to a1 on sheet 2 and type in =Quotation!D20 how do i make it so that this is invisable when there is nothing posted in sheet one
its easier if i give u an example
i got 2 sheets in excel Sheet1 and Sheet2. i go to a1 on sheet 2 and type in =Quotation!D20 how do i make it so that this is invisable when there is nothing posted in sheet one
Last edited by Ben Lester; 09-01-2010 at 12:16 PM.
Maybe
=IF(ISBLANK(Quotation!D20),"",Quotation!D20 )
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks