Looking for blank unlees C1 has an entry

[mikerules]

=+$D$39/'Ship$mart Imput Summary'!A14


I have the formula in multiple cells however I only want to see the result if an entry has been made to C1

[Mazzaropi]

mikerules, Good evening.

Try this one:

=IF(C1="","",+$D$39/'Ship$mart Imput Summary'!A14)

Is this what you want?
I hope it helps.

[martindwilson]

what is the + for ? it's not needed in excel

[mikerules]

Thanks that's great. If you would like a much more complicated question have a look at my question from a couple days ago that I have not had a response to. I am desperate!!

[martindwilson]

what is the + for ? it's not needed in excel
if it was then you would logically use
=+$D$39/+'Ship$mart Imput Summary'!A14

[mikerules]

It was from an older version but thanks for your comment. Old habits die hard!

[martindwilson]

what is your older thread that needs an answer?

[mikerules]

The answer from Mazzaropi worked perfect but thank-you