| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to correct a #value error
Hi,
I have this formula =(I5)-(E6)+(G6), but when I type a letter on column E i get on I column a #VALUE ERROR. Any knows who to correct this from happenning? I need letter on the E column. Thanks for your help..... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to correct a #value error
You're getting a #VALUE error because you can't add letters. What are you
trying to do? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "tony" wrote: Hi, I have this formula =(I5)-(E6)+(G6), but when I type a letter on column E i get on I column a #VALUE ERROR. Any knows who to correct this from happenning? I need letter on the E column. Thanks for your help..... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to correct a #value error
try
=if(isnumber(E6),I5-E6+G6, "otherwise") repalcing the otherwise with what you want it to do when you have a letter in e6. if letters can be is any of them =if(and(isnumber(E6),isnumber(I5),isnumber(G6)),I5-E6+G6, "otherwise") "tony" wrote: Hi, I have this formula =(I5)-(E6)+(G6), but when I type a letter on column E i get on I column a #VALUE ERROR. Any knows who to correct this from happenning? I need letter on the E column. Thanks for your help..... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to correct a #value error
6 + x -10 / Tuesday = Blue
must be that New Math... "bj" wrote: try =if(isnumber(E6),I5-E6+G6, "otherwise") repalcing the otherwise with what you want it to do when you have a letter in e6. if letters can be is any of them =if(and(isnumber(E6),isnumber(I5),isnumber(G6)),I5-E6+G6, "otherwise") "tony" wrote: Hi, I have this formula =(I5)-(E6)+(G6), but when I type a letter on column E i get on I column a #VALUE ERROR. Any knows who to correct this from happenning? I need letter on the E column. Thanks for your help..... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to correct a #value error
I try both form and still dosen't work.....
now it said otherwise..... "dlw" wrote: 6 + x -10 / Tuesday = Blue must be that New Math... "bj" wrote: try =if(isnumber(E6),I5-E6+G6, "otherwise") repalcing the otherwise with what you want it to do when you have a letter in e6. if letters can be is any of them =if(and(isnumber(E6),isnumber(I5),isnumber(G6)),I5-E6+G6, "otherwise") "tony" wrote: Hi, I have this formula =(I5)-(E6)+(G6), but when I type a letter on column E i get on I column a #VALUE ERROR. Any knows who to correct this from happenning? I need letter on the E column. Thanks for your help..... |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to correct a #value error
Still dosen't work... know says otherwise.....
"bj" wrote: try =if(isnumber(E6),I5-E6+G6, "otherwise") repalcing the otherwise with what you want it to do when you have a letter in e6. if letters can be is any of them =if(and(isnumber(E6),isnumber(I5),isnumber(G6)),I5-E6+G6, "otherwise") "tony" wrote: Hi, I have this formula =(I5)-(E6)+(G6), but when I type a letter on column E i get on I column a #VALUE ERROR. Any knows who to correct this from happenning? I need letter on the E column. Thanks for your help..... |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to correct a #value error
What do you want it to show?
"tony" wrote: Still dosen't work... know says otherwise..... "bj" wrote: try =if(isnumber(E6),I5-E6+G6, "otherwise") repalcing the otherwise with what you want it to do when you have a letter in e6. if letters can be is any of them =if(and(isnumber(E6),isnumber(I5),isnumber(G6)),I5-E6+G6, "otherwise") "tony" wrote: Hi, I have this formula =(I5)-(E6)+(G6), but when I type a letter on column E i get on I column a #VALUE ERROR. Any knows who to correct this from happenning? I need letter on the E column. Thanks for your help..... |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to correct a #value error
The formula dosen't add. I just want to be able to add and include text on
that column. "bj" wrote: What do you want it to show? "tony" wrote: Still dosen't work... know says otherwise..... "bj" wrote: try =if(isnumber(E6),I5-E6+G6, "otherwise") repalcing the otherwise with what you want it to do when you have a letter in e6. if letters can be is any of them =if(and(isnumber(E6),isnumber(I5),isnumber(G6)),I5-E6+G6, "otherwise") "tony" wrote: Hi, I have this formula =(I5)-(E6)+(G6), but when I type a letter on column E i get on I column a #VALUE ERROR. Any knows who to correct this from happenning? I need letter on the E column. Thanks for your help..... |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to correct a #value error
Do you want to concatinate text?
Please give an example of the input values and what you want the result to be? "tony" wrote: The formula dosen't add. I just want to be able to add and include text on that column. "bj" wrote: What do you want it to show? "tony" wrote: Still dosen't work... know says otherwise..... "bj" wrote: try =if(isnumber(E6),I5-E6+G6, "otherwise") repalcing the otherwise with what you want it to do when you have a letter in e6. if letters can be is any of them =if(and(isnumber(E6),isnumber(I5),isnumber(G6)),I5-E6+G6, "otherwise") "tony" wrote: Hi, I have this formula =(I5)-(E6)+(G6), but when I type a letter on column E i get on I column a #VALUE ERROR. Any knows who to correct this from happenning? I need letter on the E column. Thanks for your help..... |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to correct a #value error
124645 | | 118,385.43 | | (95,233.09)
124646 | | a/p | | #VALUE! 124622 | | A/P | | 1,425,084.08 124623 | | A/P | 38,302.58 | 1,463,386.66 If I remove the a/p on column e I get the correct balance. This is a check register. I want to have a balance insted an error. The funny part is on my original sheet is ok but I copy the sheet to another and is giving me this error. "bj" wrote: Do you want to concatinate text? Please give an example of the input values and what you want the result to be? "tony" wrote: The formula dosen't add. I just want to be able to add and include text on that column. "bj" wrote: What do you want it to show? "tony" wrote: Still dosen't work... know says otherwise..... "bj" wrote: try =if(isnumber(E6),I5-E6+G6, "otherwise") repalcing the otherwise with what you want it to do when you have a letter in e6. if letters can be is any of them =if(and(isnumber(E6),isnumber(I5),isnumber(G6)),I5-E6+G6, "otherwise") "tony" wrote: Hi, I have this formula =(I5)-(E6)+(G6), but when I type a letter on column E i get on I column a #VALUE ERROR. Any knows who to correct this from happenning? I need letter on the E column. Thanks for your help..... |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to correct a #value error
Try
=I5+G6-if(isnumber(E6),E6,0) "tony" wrote: 124645 | | 118,385.43 | | (95,233.09) 124646 | | a/p | | #VALUE! 124622 | | A/P | | 1,425,084.08 124623 | | A/P | 38,302.58 | 1,463,386.66 If I remove the a/p on column e I get the correct balance. This is a check register. I want to have a balance insted an error. The funny part is on my original sheet is ok but I copy the sheet to another and is giving me this error. "bj" wrote: Do you want to concatinate text? Please give an example of the input values and what you want the result to be? "tony" wrote: The formula dosen't add. I just want to be able to add and include text on that column. "bj" wrote: What do you want it to show? "tony" wrote: Still dosen't work... know says otherwise..... "bj" wrote: try =if(isnumber(E6),I5-E6+G6, "otherwise") repalcing the otherwise with what you want it to do when you have a letter in e6. if letters can be is any of them =if(and(isnumber(E6),isnumber(I5),isnumber(G6)),I5-E6+G6, "otherwise") "tony" wrote: Hi, I have this formula =(I5)-(E6)+(G6), but when I type a letter on column E i get on I column a #VALUE ERROR. Any knows who to correct this from happenning? I need letter on the E column. Thanks for your help..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I correct error using the =IF(AND(formula in excel? | Excel Worksheet Functions | |||
| How do I correct error using the =IF(AND(formula in excel? | Excel Worksheet Functions | |||
| How do I correct the #DIV/0! error? | Excel Worksheet Functions | |||
| How do I correct a #value! error | Excel Discussion (Misc queries) | |||
| Please help correct a simple error | New Users to Excel | |||
Linear Mode
