IF formula

[Phoenix]

See attachment:

How can i write the same IF formula if "x" is marked for 1.1, 1.4, an
1.9 also in the same cell?? The "x" will only be marked for one at th
same time....but i never know witch of them. Therefore I want on
formula that covers them all.

Phoeni

Attachment filename: if formula.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=46184

 

[A.W.J. Ales]

Phoenix,

=H4*I4*IF(ISNA(MATCH("x",J4:M4)),1,INDEX(J3:M3,MATCH("x",J4:M4)))

(I'm not sure whether the , is correct. In my setting (dutch) I use a ; as
argument separator.
I assumed you use a , and i adapted the formula to it. If necessary you
have to change that back again.)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Frank Kabel]

Hi auk
I think you meant
=H4*I4*IF(ISNA(MATCH("x",J4:M4,0)),1,INDEX(J3:M3,MATCH("x",J4:M4,0)))

 

[A.W.J. Ales]

Hi Frank,

Agreed. Although (since there will be or none or just one "x") you could
do without but it's safer to add that last argument as well.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Phoenix]

Thanx guys. It works perfect now :-

 

[A.W.J. Ales]

YW Phoenix and thanks for the feedback.
Always nice to know that the problem is solved.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *