View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Return error #VALUE!

What's in E3?
What's in G3?
What's in D3?

If they're really all numbers, maybe you want:

=IF(D3=0,"",(E3/2000)*(G3/D3))

(you can't multiply "" by g3/d3.)



GYoder wrote:

Why do I get this error with this formula? =IF(D3=0,"",E3/2000)*(G3/D3)


--

Dave Peterson