ExcelBanter - Return error #VALUE!

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Return error #VALUE! (https://www.excelbanter.com/new-users-excel/185130-return-error-value.html)

GYoder

Return error #VALUE!

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

Dave Peterson

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

All times are GMT +1. The time now is 05:24 PM.