| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Why #VALUE
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Why #VALUE
.. when there is no data in col b,c,d 2
the response in e2 is # value 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "pcor" wrote: 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Why #VALUE
ok thanks
"Max" wrote: .. when there is no data in col b,c,d 2 the response in e2 is # value 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "pcor" wrote: 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Why #VALUE
welcome
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "pcor" wrote in message ... ok thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
