Posted to microsoft.public.excel.worksheet.functions

Steved

external usenet poster

Posts: 519

giving me #Value!

Hello from Steved

If A5 and B5 is The Same as C5 and D5 then display "dup" please

=IF(LEFT(A5,3)=LEFT(b5,3),"dup","")+=IF(LEFT(c5,3) =LEFT(d5,3),"dup","")

Thankyou

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
SUMIF giving me 0	Gerrie	Excel Discussion (Misc queries)	10	April 24th 09 06:25 PM
Vlookup giving #N/A	matt_the_brum	Excel Worksheet Functions	12	August 4th 06 09:17 AM
Sumproduct giving #NA	Gary	Excel Worksheet Functions	2	August 3rd 06 11:47 AM
Giving value to a letter	=!CmOrE!=	Excel Worksheet Functions	6	July 21st 06 01:56 AM
My formula Is giving me a #NAME!	Steved	Excel Worksheet Functions	3	June 16th 05 08:18 PM

All times are GMT +1. The time now is 07:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us