IF formula

  • Thread starter Thread starter Phoenix
  • Start date Start date
P

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
 
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 *
 
Hi auk
I think you meant
=H4*I4*IF(ISNA(MATCH("x",J4:M4,0)),1,INDEX(J3:M3,MATCH("x",J4:M4,0)))
 
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 *
 
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 *
 
Back
Top