ISERROR assistance

[robertguy]

Hi,

can any please advise me of the syntax I require to add ISERROR to my formula =((L2-K2)/10)+L2 so that if the result is #Value! the cell will display as blank i.e. empty


Any assistance would be greatly appreciated

Many thanks in advance

Regards


Rob

[samba_ravi]

=if(iserror(((L2-K2)/10)+L2,"",((L2-K2)/10)+L2)
or
=iferror(((L2-K2)/10)+L2,"")

[Special-K]

Just place IFERROR(formula,result if error)

=IFERROR(((L2-K2)/10)+L2,"")

[Tony Valko]

What version of Excel are you using?

One way...

=IF(COUNT(L2,K2)<2,"",((L2-K2)/10)+L2)

[Jaffary]

Hi Robertguy,

i also recommend to use IFERROR()

Just place IFERROR(formula,result if error)

=IFERROR(((L2-K2)/10)+L2,"")