Thanks for the feedback. Glad I could help.

"Mukesh" wrote:

Thanks....this worked!


"FloMM2" wrote:

Mukesh,
If I understand your problem....
If there is a value in D21, multiply it by 1000 and divide that by the value
in L3.
If there is not a value in D21 and there is in I21, then multiply I21 by
1000 and divide it by the value in L3.
To accomplish the above:
"=IF(D210,D21*1000/L3,I21*1000/L3)"

The issue with "#VLAUE" is excel does not like to divide by zero.

HTH
:-)

"Mukesh" wrote:

I need return value in cell (D4) ....IF(OR) one
or both cells have the numbers, for example.

I am trying to do in cell D4 is.....
=IF(OR(D21,I21), D21*1000/L3, I21*1000/L3)

it returns correct value from cell D21, but from cell I21..
won't show up! and when both cells (D21 & I21) are
empty, the result cell (D4) shows " #VALUE! "

Please help, how do I solve this?

Thanks.
Mukesh