=+$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
=+$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
mikerules, Good evening.
Try this one:
=IF(C1="","",+$D$39/'Ship$mart Imput Summary'!A14)
Is this what you want?
I hope it helps.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
what is the + for ? it's not needed in excel
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
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!!
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
It was from an older version but thanks for your comment. Old habits die hard!
what is your older thread that needs an answer?
The answer from Mazzaropi worked perfect but thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks