View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
[email protected] themurph555@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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!