Trouble with formula - ExcelBanter

Kristajea

Posts: n/a

Trouble with formula

I am trying to get the following formula to work:

=IF(OR(P13=835,P13=384,P13=386,P13=364),(CONCATENA TE(P13,R13,0,0)),(IF(P13=585,(CONCATENATE(583,R13, 0,0))),(IF(P13=627,(CONCATENATE(0,30,R13,0,0))),(I F(P13=7,(CONCATENATE(0,17,R13,0,0))),(IF(P13=646,( CONCATENATE(147,R13,0,0))))))))

IF P13 = anything other than the numbers in the first section of the
formula, I get a #VALUE error. I am using this to assist a data entry
function.

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
Trouble with Syntax - IF formula	Bert via OfficeKB.com	New Users to Excel	1	April 8th 05 01:00 AM
Howdo U copy a formula down a column, that uses data in another w.	Need Help pasting a formula	Excel Worksheet Functions	1	February 25th 05 06:04 PM
Howdo U copy a formula down a column, that uses data in another w.	brantty	Excel Worksheet Functions	0	February 25th 05 10:11 AM
Problem with VBA returning the contents of a long formula.	[email protected]	Excel Discussion (Misc queries)	2	February 23rd 05 12:14 AM
How do I use Range Names listed in a VLookup table in a formula?	Essbasedvlpr32	Excel Worksheet Functions	3	December 15th 04 10:11 PM

All times are GMT +1. The time now is 02:19 PM.

Menu

About Us