ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Check for errors (https://www.excelbanter.com/excel-worksheet-functions/14821-check-errors.html)

Pat

Check for errors
 
The following formula presumes there is data in N75 and J75

=IF(ISNUMBER($R75)*($R75<0),"",IF(AND($N75-$J750,$Q75=1),0,$N75-$J75))

When no data can be found #VALUE! error is returned. I need to have the
formula to be returned without any errors.

I have tried varies combinations but none were successful. Here is one of
them:

=IF(ISNUMBER($R74)*($R74<0),"",IF(AND(ISNUMBER($N 74)-($J740),$Q74=1),0,ISNUMBER($N74)-($J74)))


Thanks if you can fix it.
Pat



Peo Sjoblom

You can only get a value error if any cell you do a calculation with is
text, this should probably dow (not tested

=IF(OR(ISTEXT(N$75),ISTEXT(J$75)),"",IF(ISNUMBER($ R75)*($R75<0),"",IF(AND($
N75-$J750,$Q75=1),0,$N75-$J75)))

--

Regards,

Peo Sjoblom

"Pat" wrote in message
...
The following formula presumes there is data in N75 and J75

=IF(ISNUMBER($R75)*($R75<0),"",IF(AND($N75-$J750,$Q75=1),0,$N75-$J75))

When no data can be found #VALUE! error is returned. I need to have the
formula to be returned without any errors.

I have tried varies combinations but none were successful. Here is one of
them:


=IF(ISNUMBER($R74)*($R74<0),"",IF(AND(ISNUMBER($N 74)-($J740),$Q74=1),0,ISN
UMBER($N74)-($J74)))


Thanks if you can fix it.
Pat





Pat

That sorted it.
Many thanks.
Pat

P.S. I take note of your comments of your other post. I posted the same
message twice, because I noticed that it did not appear as a new post but
had in fact attached itself to an earlier post (30/Jan/2005) of mines with
the same subject heading. I am now assuming that I am the only one who can
observe this. Thanks any way for pointing that out to me.



"Peo Sjoblom" wrote in message
...
You can only get a value error if any cell you do a calculation with is
text, this should probably dow (not tested


=IF(OR(ISTEXT(N$75),ISTEXT(J$75)),"",IF(ISNUMBER($ R75)*($R75<0),"",IF(AND($
N75-$J750,$Q75=1),0,$N75-$J75)))

--

Regards,

Peo Sjoblom

"Pat" wrote in message
...
The following formula presumes there is data in N75 and J75

=IF(ISNUMBER($R75)*($R75<0),"",IF(AND($N75-$J750,$Q75=1),0,$N75-$J75))

When no data can be found #VALUE! error is returned. I need to have

the
formula to be returned without any errors.

I have tried varies combinations but none were successful. Here is one

of
them:



=IF(ISNUMBER($R74)*($R74<0),"",IF(AND(ISNUMBER($N 74)-($J740),$Q74=1),0,ISN
UMBER($N74)-($J74)))


Thanks if you can fix it.
Pat







Peo Sjoblom

Never trust OE when it comes to handling newsgroup threads <g

--

Regards,

Peo Sjoblom


"Pat" wrote in message
...
That sorted it.
Many thanks.
Pat

P.S. I take note of your comments of your other post. I posted the same
message twice, because I noticed that it did not appear as a new post but
had in fact attached itself to an earlier post (30/Jan/2005) of mines with
the same subject heading. I am now assuming that I am the only one who

can
observe this. Thanks any way for pointing that out to me.



"Peo Sjoblom" wrote in message
...
You can only get a value error if any cell you do a calculation with is
text, this should probably dow (not tested



=IF(OR(ISTEXT(N$75),ISTEXT(J$75)),"",IF(ISNUMBER($ R75)*($R75<0),"",IF(AND($
N75-$J750,$Q75=1),0,$N75-$J75)))

--

Regards,

Peo Sjoblom

"Pat" wrote in message
...
The following formula presumes there is data in N75 and J75


=IF(ISNUMBER($R75)*($R75<0),"",IF(AND($N75-$J750,$Q75=1),0,$N75-$J75))

When no data can be found #VALUE! error is returned. I need to have

the
formula to be returned without any errors.

I have tried varies combinations but none were successful. Here is one

of
them:




=IF(ISNUMBER($R74)*($R74<0),"",IF(AND(ISNUMBER($N 74)-($J740),$Q74=1),0,ISN
UMBER($N74)-($J74)))


Thanks if you can fix it.
Pat










All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com