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

O

osuhoosier

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
 
P

Peo Sjoblom

=MOD(A1,1)

will return decimal

--
Regards,

Peo Sjoblom

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

Nick Hodge

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(A1>100,MOD(A1,1),A1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top