How to use formula to get

  • Thread starter Thread starter crapit
  • Start date Start date
C

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
 
Try this in I1:

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

Copy down as required.

Hope this helps.

Pete
 
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
Click to expand...

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


Regards
Claus Busch
 
what does the h1*1 means??

Claus Busch said:
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
Click to expand...
 
Back
Top