IF Formula Help

[Justinian]

In cell A2 is the number 78.13. I am trying to write a formula that rounds A2 down if the last digits is between 0 and 5 and round up if the last is between 6 and 9. This formulas does round down if the number is less than 5 but it will not round up when the number is 5 or greater.

=IF(AND(RIGHT(A2)<5,RIGHT(A2)>0),ROUNDDOWN(A2,0),ROUNDUP(A2,0))

 

[JoeMo]

Number is 78.13.

If you enter in any empty cell:
=TYPE(A2)
what do you get?

 

[Justinian]

-1.

 

[JoeMo]

-1.

That's not possible.
TYPE can only return:
1 if the value is a number
2 if the value is text
4 if a logical value
16 if an error
64 if an array formula

 

[Justinian]

I keep getting -1 when using TYPE so I don't know what's happening.

 

[bbott]

I keep getting -1 when using TYPE so I don't know what's happening.

Perhaps you accidentally hit - and = at the same time?

=-TYPE(A2)

 

[Justinian]

No, I swear I just hit =TYPE(A2). A2 is formatted as a percentage but either way, the formula works now. I just don't get why -1 is showing.