I need to if then

[CommanderGraham]

I've got 100000+ numbers in a field.
If the last 2 digits, and only the last 2 = 00, i want to drop the 00's.......?
Thanks

[CommanderGraham]

correct that....i only want to analyze the last two digits for the 00's

[CommanderGraham]

Got it..........

[tkowal]

Confused???

My assumption is that if the last 2 digits of the number is "00" then use the previous two digits before the "00" and if the last two digits are not "00" then just them....


Try this formula in a cell and copy down as needed:

Please Login or Register  to view this content.

[shg]

=if(mod(a1, 100)=0, a1/100, a1)

[tkowal]

shg solution is more efficient and cleaner ---- that's why he's a guru !