| 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 |
| 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 | |||
Threaded Mode
