Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
Auto spell check as in word | Excel Discussion (Misc queries) | |||
check box formatting | Excel Discussion (Misc queries) | |||
spell check protected document | Excel Discussion (Misc queries) | |||
Creating a check box that does not require security clearance. | Excel Worksheet Functions |