cell returns wrong value

G

garyww

I have the cell return wrong value

ie. M cell returns #VALUE!
where M cell forumla is =SUM(I2*AU2)
I2= 20871

and
AU2 cell is no value pluged in"
where AU2
=IF(ISERROR((AM2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AL2),
"",ROUND((AM2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AL2,3))


Now, I do not want the M cell returns with #VALUE!, i want it blank or
if the
future there is a value in AU2, it returns a correct number.

thanks
gar
email: (e-mail address removed)
 
D

Dav

in the M cell if(iserror(sum(I2*AU2)),"",sum(I2*AU2))

Is I think what you require, it is not entirely clear from your post

Regards

Dav
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top