Hi there
First post, hopefully I've followed the rules. I've had a good search but can't find anything specific to the issue I am having. It's very basic so I'm surprised it isn't working.
I've attached an image that hopefully clearly explains the issue I am having. Basically I'd like to return specific text (or remain blank/empty) in a cell based on Nested If statements working from a cell that contains a LEN function to total up some characters in another cell. I've researched a few sites and this should work, I can't figure it out. I've tried the words Website and Amazon with and without quote marks either side of them but this doesn't make any difference.
Thanks in advance for any help and support that can be provided.
Paul
First post, hopefully I've followed the rules. I've had a good search but can't find anything specific to the issue I am having. It's very basic so I'm surprised it isn't working.
I've attached an image that hopefully clearly explains the issue I am having. Basically I'd like to return specific text (or remain blank/empty) in a cell based on Nested If statements working from a cell that contains a LEN function to total up some characters in another cell. I've researched a few sites and this should work, I can't figure it out. I've tried the words Website and Amazon with and without quote marks either side of them but this doesn't make any difference.
Thanks in advance for any help and support that can be provided.
Paul