Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#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) "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 |
#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(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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying a formula to a drop menu choice | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Filling drop down box | Excel Discussion (Misc queries) |