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?

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

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?

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

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