Have a cell information invisible until criteria is established

[tstowe]

I done a search and scanned through the posts and did not find an answer to my problem which I hope to have answered here.

I have Column C doing a very basic calculation such as: Cell C3 = +C2-B3. The entire column is doing this and currently I have three sheets being printed because of the formula doing what I am asking it to do but I do not have a quantity listed in most of the cells in Column B although it is possible that different jobs will require multiple pages. My end goal is to have the spreadsheet set so that I will not have to waste time copying and pasting that forumla and changing the sheet all the time.

What I would like to have happen is for excel to look at Cell B3 and if blank, not to run the calculation and leave the Cell C3 blank while retaining the formula.

If this is possible I would appreciate your help and thanks ahead of time.

Tony

 

[SQLBI]

Tony

Use

=IF(B3="","",C2-B3)

and copy this to all the relevant cells.

Then C3 etc will contain "" or Blank values until B3 is updated.

Hope this helps.


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[tstowe]

That was too simple! Thanks for your time and have a good day.

 

[SQLBI]

Tony,

It's only simple if you know how to do it!

Cheers,


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk