Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula presumes cells have data
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
|
|||
|
|||
No need to post same question more than once
-- 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 | |||
Need Formula to display pivot table source data | Excel Worksheet Functions | |||
How do i select different cells to be use in a formula. | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
Formula to Extract Data from a Table | Excel Worksheet Functions |