Sunline
Well-known Member
- Joined
- Oct 6, 2007
- Messages
- 701
- Office Version
- 2016
- Platform
- Windows
Hello all , i have this function which is returning #DIV/0! error if cells MR2 and MZ2 contains a zero 0 .
=(MP2/MR2)*MZ2
Col MP contains the number 100 always .
Col MR contains numbers .
Col MZ contains numbers .
I would like answer in col NA2 too return zero 0 , not DIV error , if only zero.s are found in cols MR2 and MZ2 .
Thanks .
=(MP2/MR2)*MZ2
Col MP contains the number 100 always .
Col MR contains numbers .
Col MZ contains numbers .
I would like answer in col NA2 too return zero 0 , not DIV error , if only zero.s are found in cols MR2 and MZ2 .
Thanks .