| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM
hello,
i have some problem which i mentioned is as under: A1 B1(this cell has vlookup formula) C1(result) 1000 900 =SUM(A1-B1) #VALUE! error is coming out if B1 is empty otherwise is ok. thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(....)
This puts a 0 in place of a blank or #N/A error. Then your sum will work correctly. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Tufail" wrote: hello, i have some problem which i mentioned is as under: A1 B1(this cell has vlookup formula) C1(result) 1000 900 =SUM(A1-B1) #VALUE! error is coming out if B1 is empty otherwise is ok. thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM
Try:
=(IF(ISNUMBER(B1),A1-B1,A1)) "Tufail" wrote: hello, i have some problem which i mentioned is as under: A1 B1(this cell has vlookup formula) C1(result) 1000 900 =SUM(A1-B1) #VALUE! error is coming out if B1 is empty otherwise is ok. thanks in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM
thank you very much it's working.
"Toppers" wrote: Try: =(IF(ISNUMBER(B1),A1-B1,A1)) "Tufail" wrote: hello, i have some problem which i mentioned is as under: A1 B1(this cell has vlookup formula) C1(result) 1000 900 =SUM(A1-B1) #VALUE! error is coming out if B1 is empty otherwise is ok. thanks in advance. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM
Try this:
=IF(COUNT(A1:B1)<2,"",A1-B1) Biff "Tufail" wrote in message ... hello, i have some problem which i mentioned is as under: A1 B1(this cell has vlookup formula) C1(result) 1000 900 =SUM(A1-B1) #VALUE! error is coming out if B1 is empty otherwise is ok. thanks in advance. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM
thank you very much it's working too.
"T. Valko" wrote: Try this: =IF(COUNT(A1:B1)<2,"",A1-B1) Biff "Tufail" wrote in message ... hello, i have some problem which i mentioned is as under: A1 B1(this cell has vlookup formula) C1(result) 1000 900 =SUM(A1-B1) #VALUE! error is coming out if B1 is empty otherwise is ok. thanks in advance. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM
You're welcome. Thanks for the feedback!
Biff "Tufail" wrote in message ... thank you very much it's working too. "T. Valko" wrote: Try this: =IF(COUNT(A1:B1)<2,"",A1-B1) Biff "Tufail" wrote in message ... hello, i have some problem which i mentioned is as under: A1 B1(this cell has vlookup formula) C1(result) 1000 900 =SUM(A1-B1) #VALUE! error is coming out if B1 is empty otherwise is ok. thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
