How to use formula to get

[crapit]

Hi,
How do I set the formla in column I in such a way that the output is
determine by column H value? i.e if H1 = 01, I1 = C1, etc. I try using if
(and if loop) but keep on getting FALSE.


C D E F G H I
1 set1 set2 01 set1
2 set1 set2 02 set1 + set2
3 set1 set2 03 set2

 

[Pete_UK]

Try this in I1:

=IF(H1="01",C1,IF(H1="03",D1,C1&" + "&D1))

Copy down as required.

Hope this helps.

Pete

 

[Claus Busch]

Hi Crapit,

Am Tue, 10 Nov 2009 23:26:06 +0800 schrieb crapit:

C D E F G H I
1 set1 set2 01 set1
2 set1 set2 02 set1 + set2
3 set1 set2 03 set2

try this in I1:
=CHOOSE(H1*1,C1,C1&" + "&D1,D1)


Regards
Claus Busch

 

[crapit]

what does the h1*1 means??

Hi Crapit,

Am Tue, 10 Nov 2009 23:26:06 +0800 schrieb crapit:


try this in I1:
=CHOOSE(H1*1,C1,C1&" + "&D1,D1)


Regards
Claus Busch