Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why am I getting a #VALUE! error?
Hopefully, this is the correct forum in which to ask this question.
In Cell K320, when the formula is =K182 I get a blank (zero) But when the formula in in that same cell is =K182+IF(A440,($J$202/$U$202)/12,0) I get a #VALUE! error A similar formula in Cell K308 =SUM(K158:K178)+IF(A150,($J$202/$U$202)/12,0) works fine. I can't figure out why it's not working in K320. Thanks, in advance, for any help you can provide. Dan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why am I getting a #VALUE! error?
The + operator returns #VALUE if either of its arguments are Text.
In article , crimsonkng wrote: Hopefully, this is the correct forum in which to ask this question. In Cell K320, when the formula is =K182 I get a blank (zero) But when the formula in in that same cell is =K182+IF(A440,($J$202/$U$202)/12,0) I get a #VALUE! error A similar formula in Cell K308 =SUM(K158:K178)+IF(A150,($J$202/$U$202)/12,0) works fine. I can't figure out why it's not working in K320. Thanks, in advance, for any help you can provide. Dan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why am I getting a #VALUE! error?
Hi
What you do have in cell K182 ? When nothing, then with + operator Excel assumes that it is an empty string, i.e. you formula is same as = "" + SomeNumber You can't add strings and numbers, i.e. the formula returns an error. Try instead =SUM(K182,IF(A440,($J$202/$U$202)/12,0)) Unlike + operator, the SUM function ignores empty cells. Arvi Laanemets "crimsonkng" wrote in message ... Hopefully, this is the correct forum in which to ask this question. In Cell K320, when the formula is =K182 I get a blank (zero) But when the formula in in that same cell is =K182+IF(A440,($J$202/$U$202)/12,0) I get a #VALUE! error A similar formula in Cell K308 =SUM(K158:K178)+IF(A150,($J$202/$U$202)/12,0) works fine. I can't figure out why it's not working in K320. Thanks, in advance, for any help you can provide. Dan |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why am I getting a #VALUE! error?
Text, huh? Hmmmm, that's odd. I didn't realize that I had text in those
cells. OK, I'll take a look. Thanks for your help. Dan "JE McGimpsey" wrote: The + operator returns #VALUE if either of its arguments are Text. In article , crimsonkng wrote: Hopefully, this is the correct forum in which to ask this question. In Cell K320, when the formula is =K182 I get a blank (zero) But when the formula in in that same cell is =K182+IF(A440,($J$202/$U$202)/12,0) I get a #VALUE! error A similar formula in Cell K308 =SUM(K158:K178)+IF(A150,($J$202/$U$202)/12,0) works fine. I can't figure out why it's not working in K320. Thanks, in advance, for any help you can provide. Dan |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why am I getting a #VALUE! error?
Yer a pal.
Dan "Arvi Laanemets" wrote: Hi What you do have in cell K182 ? When nothing, then with + operator Excel assumes that it is an empty string, i.e. you formula is same as = "" + SomeNumber You can't add strings and numbers, i.e. the formula returns an error. Try instead =SUM(K182,IF(A440,($J$202/$U$202)/12,0)) Unlike + operator, the SUM function ignores empty cells. Arvi Laanemets "crimsonkng" wrote in message ... Hopefully, this is the correct forum in which to ask this question. In Cell K320, when the formula is =K182 I get a blank (zero) But when the formula in in that same cell is =K182+IF(A440,($J$202/$U$202)/12,0) I get a #VALUE! error A similar formula in Cell K308 =SUM(K158:K178)+IF(A150,($J$202/$U$202)/12,0) works fine. I can't figure out why it's not working in K320. Thanks, in advance, for any help you can provide. Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) |