ISERROR function to remove #VALUE

[singerbatfink]

Hi,

I cant get the ISERROR function in this if statement to remove the #VALUE, could someone tell me what Ive done wrong here?

=IF(ISERROR((N3<M3,ROUND(O3,1)&" "&C3&" Interviews Short of Benchmark ",ROUND(O3,1)&" Surplus Interviews Booked"))," ",(N3<M3,ROUND(O3,1)&" "&C3&" Interviews Short of Benchmark ",ROUND(O3,1)&" Surplus Interviews Booked"))

Thanks in advance.

B

[Richard Buttrey]

Hi,

Difficult to be sure without seeing the formula in context, i.e. in the workbook, but try:

=IF(ISERROR(N3<M3),ROUND(O3,1)&" "&C3&" Interviews Short of Benchmark ",ROUND(O3,1)&" Surplus Interviews Booked")

HTH

[singerbatfink]

Hi Richard,

Thanks for your prompt response. I did try your suggestion but it still returned the error.

Ive attached a scenario so you can have a better look at it.

Regards

B

[KiPA]

Why is there that C3 in value_if_true merge? Because with this logic it would be empty (because there would be nothing in C3) so that it would be unnecessary in the first place.

Edit: never mind

[singerbatfink]

Thanks arthurbr,

Thats got rid of the #VALUE. How do I now make the cell look blank if there is no data in the table?

B

[Richard Buttrey]

Hi,

Why not just

=IF(O3="","",IF(N3<M3,ROUND(O3,1)&" "&C3&" Interviews Short of Benchmark ",ROUND(O3,1)&" Surplus Interviews Booked"))

Rgds

[singerbatfink]

Thanks for the help.. Great stuff..

[arthurbr]

Is the attached what you need?