Posted to microsoft.public.excel.misc

dlw

external usenet poster

Posts: 510

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I correct error using the =IF(AND(formula in excel?	Redwing ML	Excel Worksheet Functions	0	March 1st 06 03:20 PM
How do I correct error using the =IF(AND(formula in excel?	Redwing ML	Excel Worksheet Functions	6	March 1st 06 01:24 PM
How do I correct the #DIV/0! error?	sony654	Excel Worksheet Functions	5	April 17th 05 09:52 AM
How do I correct a #value! error	How do I eliminate a #value! error?	Excel Discussion (Misc queries)	6	December 16th 04 02:33 PM
Please help correct a simple error	lwhite	New Users to Excel	1	December 9th 04 09:39 PM

All times are GMT +1. The time now is 10:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us