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.....
|