formula doesn't work - ExcelBanter

Posted to microsoft.public.excel.programming

davegb[_3_] davegb[_3_] is offline

external usenet poster

Posts: 3

formula doesn't work

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formula to work in a 3-d reference with 2 work books	capt c	Excel Worksheet Functions	1	April 8th 09 08:04 PM
Sorting the cells of a formula causes the formula to not work	Jake	Excel Worksheet Functions	3	January 31st 09 04:42 AM
How does this formula work?	[email protected]	Excel Discussion (Misc queries)	4	May 9th 06 09:10 PM
A search for $ in a formula use to work now it does not work	JuneJuly	Excel Discussion (Misc queries)	2	November 30th 05 10:13 PM
extract a foldername with a formula-update formula does not work	solo_razor[_16_]	Excel Programming	2	October 30th 03 03:59 PM

All times are GMT +1. The time now is 05:04 AM.

Menu

About Us