Using a IF formula, I would like to drop the 2 digits in front of.
 

Using a IF formula, I would like to drop the 2 digits in front of the
decimal, and only use the 2 digits after the decimal

=MOD(A1,1)

will return decimal

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"osuhoosier" wrote in message
...
Using a IF formula, I would like to drop the 2 digits in front of the
decimal, and only use the 2 digits after the decimal

Not sure I get this but the formula below returns the decimal of a number in
A1 if it's value is over 100 otherwise returns the entire number?????

=IF(A1100,MOD(A1,1),A1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"osuhoosier" wrote in message
...
Using a IF formula, I would like to drop the 2 digits in front of the
decimal, and only use the 2 digits after the decimal