Removing #NUM error when cell is blank

[meejo]

I'm creating a document with the following formula, it has data in it that won't yet be available so will be updated. I've been trying to amend the formula for tables that are awaiting data and the cell is blank but with no joy. Please help!

=IF(IW4=LARGE(IW4:IW23,1),1,"")

[alansidman]

wrap your existing IF statement in an iferror function

Look at this explanation: http://office.microsoft.com/en-us/ex...001231765.aspx

[meejo]

I did try doing that but couldn't quite work it out, sleep deprivation

Thank you for the speedy response by the way

[judgeh59]

try

=IFERROR(IF(IW4=LARGE(IW4:IW23,1),1,""),"What you want to have instead of the #N/A")

is this what you tried?

HTH

Ernest

[meejo]

It wasn't, but that works perfectly, thank you so much, now I can see it I know where I was going wrong.

[judgeh59]

Glad I could help.....just a note though....forum Etiquette recommends that you mark this as solved...and if somebody helps you, give them a star....so, when you help somebody, they give you a star....just a though....have a great day

Ernest