G Guest Jan 6, 2005 #1 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
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 Jan 6, 2005 #2 =MOD(A1,1) will return decimal -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum)
=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 Jan 6, 2005 #3 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 (e-mail address removed)
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 (e-mail address removed)
