If statement problem

**Scotr** · 09-24-2011, 11:14 AM

=IF(L2592="A",'Master Factors'!$C$6,0)
=IF(L2592="B",'Master Factors'!$C$8,0)
=IF(L2592="C",'Master Factors'!$C$10,0)
=IF(L2592="D",'Master Factors'!$C$12,0)

I would like to have the equation cell consider these four formulas to populate one result. The values from "Master factors" are a numeric value.

**Marcol** · 09-24-2011, 11:28 AM

Is nesting the ifs what you need?

Please Login or Register  to view this content.

Copy each formula into the previous replacing the false condition,(0), each time.

**zbor** · 09-24-2011, 11:43 AM

Or for this particular case:

=INDIRECT("'Master factors'!C"&4+2*(CODE(A2)-64))

**Scotr** · 09-24-2011, 12:18 PM

Originally Posted by Marcol

Is nesting the ifs what you need?

Please Login or Register  to view this content.

Copy each formula into the previous replacing the false condition,(0), each time.

Thank you perfect solution!

**sonuamit123** · 09-24-2011, 12:54 PM

Hi all,

There is a sheet. there are some duplicate values in it. so i want to make those duplicate values unique by adding ( _ and the number) like frag_458830 then frag_458830_1 and so on.
kindly help me.

**Marcol** · 09-24-2011, 01:04 PM

Hi sonuamit123

Welcome to the Forum ...

Read this Forum Rules before the moderators get you...

Forum Rules
2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

If you can Edit/Delete your post, do so, if not you'll need to ask a moderator to help you.

Cheers