Formula to identify decimal versus whole numbers
Hi guys
Im trying to do an IF formula that determines whether its a decimal or not.
If it IS i want to use this formala =ROUNDUP(F10/1,0)*1 so that anything above 1 = 2.
e.g if the value is 1.01+ i need the value to be 2. if its 2.01 i need it to be 3.
If its NOT a decimal then i do NOT want this formula to apply.
is there any way to do this?
Cheers!
|