Try this:

=IF(ABS(RIGHT(F27,2))80,RIGHT(F27,2)+1900,RIGHT(F 27,2))

Regards,
Per

On 12 Nov., 22:18, davegb wrote:
The following formula is supposed to take the right 2 numbers in F27 and,
if it is greater than 80, add 1900 to it. If not, just give the number. But
it always adds 1900, no mat ter how small the right 2 numbers are.

=IF(RIGHT(F27,2)80,RIGHT(F27,2)+1900,RIGHT(F27,2) )

Anyone have any ideas why RIGHT(F27,2) is always 80?