Jan 04 2021 12:57 PM
=If(cell is divisible by 50, then do so, if not return 0 zero)
How could I write this?
Jan 04 2021 01:11 PM
=IF(MOD(A1,50),0,A1/50)
The function MOD() will return the remainder after the division so in this IF() statement if the remainder is NOT 0 then it is considered true and will return 0 but if the remainder is 0 then it is false and returns A1/50
Jan 05 2021 01:05 AM