Horribly horribly urgent #name? Error to resolve - pls can someone help?

[halesowenmum]

Hi

I've got a spreadsheet with a whole host of Status's showing how complete various documents are. I've just had to change all the status's so now the formula which refers to the cell to its left and returns a particular % (of completion) figure, is totally out of whack and I am supposed to circulate this document by 10am. I have tried and tried and tried but I just cannot get it to stop doing #name?. This is the formula - does any part of the syntax look wrong?:

=IF(Z4=Content Development not started,"0%",IF(Z4=Content Development started,"25%",IF(Z4=Ready to publish,"50%",IF(Z4=Content uploaded,"60%",IF(Z4=Page created,"70%",IF(Z4=On hold,"75%",IF(Z4=Published,"<wbr style="font-family: 'trebuchet ms', sans-serif; font-size: 12.727272033691406px;">85%",IF(Z4=Signed off,"95%",IF(Z4=Complete,"100%<wbr style="font-family: 'trebuchet ms', sans-serif; font-size: 12.727272033691406px;">")))))))))

On the worksheet within this document where the status's reside they look like this:

[FONT=trebuchet ms,sans-serif]Content Development not started[/FONT]
Content Development started
Ready to publish
Content uploaded
Page created
On hold
Published
Signed off
Complete

And for each one I selected it and did Define Name so it would be named. But I'm still getting the error message and I just don't know what to do and I am desperate for someone with a better pair of eyes to have a look and tell me what is the problem here.

 

[Colin Legg]

You need " characters around the text.

=IF(Z4="Content Development not started","0%",IF(Z4="Content Development started","25%",IF(Z4="Ready to publish","50%",IF(Z4="Content uploaded","60%",IF(Z4="Page created","70%",IF(Z4="On hold","75%",IF(Z4="Published","85%",IF(Z4="Signed off","95%",IF(Z4="Complete","100%")))))))))

There are several ways this formula could be improved but I'll leave it in the format you provided since you urgently need to get your work finished.

 

[halesowenmum]

Yes - that's it - God, what a div (me, not you!!). Thank you re ideas for improvement but I'm too desperate to get this out as you say - I'll just crack on with it as it is as so long as it's producing a %, then I'm happy for the moment.

THANK YOU so MUCH