mod formula

Dear community, I need your expert advice! I am working on a sheet to calculate fees. For the amount field, I have used the following formula in "Data Validation": =MOD(E23*100;2)=0 -> The rule should avoid users to enter more than two decimal places. Now I have noticed that odd decimal...

Hello, I have used this formula: **=INDEX( MyData,INT((ROW()-ROW( $Z$1 ))/COLUMNS( MyData ))+1,MOD(ROW()-ROW( $Z$1 ),COLUMNS( MyData ))+1)** to transpose all of my rows of data into one column. Unfortunately, I can't entirely wrap my head around how it works. Would someone be willing to...

I teach computer forensics classes and we have the need for a formula that will determine if any length hex number (typically 2,3, or 4 bytes) is negative and, if so, convert that number to its negative decimal equivalent. I have been able to do that with the following formula (cell E5 contains...