Ifiserror problem

Topic

New Reply

Hi

I am trying to add an iserror to this formula =IF(J240,J24*B24,””) without success can anyone help please

I am using excel 2010

Many Thanks :confused:

Reply | Quote

Replies

Not knowing what you logic requirements are for the error condition you can try this or adjust as appropriate.
=IF(J240,IF(ISERROR(J24*B24),”Calculation Error”,J24*B24),””)
:cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

For 2010 you can use IFERROR:

=IFERROR(IF(J240,J24*B24,””),”Error message”)

Reply | Quote

Hi Guys

Thanks for the prompt reply, this works for me
Regards
Braddy

Reply | Quote