Sep 13 2021 04:30 AM
I want C23 to equal zero if A17=0 , if not then roundup(A17/B17,0)-C17. Here is what I tried IF(OR(A17="0", C23 =0), IF(A17>"0", Roundup(A17/B17,0)-C17)). Any help is greatly appreciated.
Sep 13 2021 04:34 AM - edited Sep 13 2021 04:35 AM
Sep 13 2021 04:36 AM
0 is a text value, not a number. And you cannot refer to C23 in the formula in C23. Change the formula to
=IF(A17=0, 0, ROUNDUP(A17/B17, 0)-C17)