View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.....