Why #VALUE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My spreadsheet looks something like this:
I have 5 columns as shsown below
A B C D E
DATE Insurance Deposit Rent Total


The date goes IN TO A2
iN B2( INSURAnce) I have a formula @if(now()> a2),25,"")
IN C2 (DEPOSIT)I have a formula @if(now()> a2),55,"")
IN D2 (DEPOSIT)I have a formula @if(now()> a2),45,"")
IN E2 I have then formula @sum(b2;d2)
the trouble is that when there is not data in col b,c,d 2 the response in e2
is # value
why is that
thanks
 
.. when there is no data in col b,c,d 2
the response in e2 is # value
Click to expand...

Couldn't replicate your error ..

Perhaps try instead in E2: =SUM(B2:D2)
[my version uses a colon, not a semicolon]

SUM will ignore text, hence if B2:D2 contains null strings: ""
E2 would simply return a zero

---
 
ok thanks


Max said:
.. when there is no data in col b,c,d 2
the response in e2 is # value
Click to expand...

Couldn't replicate your error ..

Perhaps try instead in E2: =SUM(B2:D2)
[my version uses a colon, not a semicolon]

SUM will ignore text, hence if B2:D2 contains null strings: ""
E2 would simply return a zero

---
pcor said:
My spreadsheet looks something like this:
I have 5 columns as shsown below
A B C D E
DATE Insurance Deposit Rent Total


The date goes IN TO A2
iN B2( INSURAnce) I have a formula @if(now()> a2),25,"")
IN C2 (DEPOSIT)I have a formula @if(now()> a2),55,"")
IN D2 (DEPOSIT)I have a formula @if(now()> a2),45,"")
IN E2 I have then formula @sum(b2;d2)
the trouble is that when there is not data in col b,c,d 2 the response in e2
is # value
why is that
thanks
Click to expand...
Click to expand...
 
Back
Top