An easy one

[batkosta]

Hi guys,

I've got the following formula in one of my cells on sheet 2:

=IF(ISNUMBER('Week 1'!E3),IF(OR('Week 1'!B3="Text1",'Week 1'!B3="Text2",'Week 1'!B3="Text3",'Week 1'!B3="Text4",'Week 1'!B3="Text5"),'Week 1'!A3,""))

The formula above is returning FALSE if 'Week 1'!E3 is non-numeric and the value of 'Week 1'!A3 if 'Week 1'!E3 contains number (assuming the OR conditions are met). The problem is that the formula is returning FALSE instead of blank as I've requested at the end of the formula. Basicly I need the value of 'Week 1'!A3 to show up if the isnumber condition is always met and one of the OR conditions is met as well.


Many thanks for your help.

K.

 

[Aladin Akyurek]

Hi guys,

I've got the following formula in one of my cells on sheet 2:

=IF(ISNUMBER('Week 1'!E3),IF(OR('Week 1'!B3="Text1",'Week 1'!B3="Text2",'Week 1'!B3="Text3",'Week 1'!B3="Text4",'Week 1'!B3="Text5"),'Week 1'!A3,""))

The formula above is returning FALSE if 'Week 1'!E3 is non-numeric and the value of 'Week 1'!A3 if 'Week 1'!E3 contains number (assuming the OR conditions are met). The problem is that the formula is returning FALSE instead of blank as I've requested at the end of the formula. Basicly I need the value of 'Week 1'!A3 to show up if the isnumber condition is always met and one of the OR conditions is met as well.


Many thanks for your help.

K.

=IF(ISNUMBER('Week 1'!E3)*ISNUMBER(MATCH('Week 1'!B3,{"Text1","Text2","Text3","Text4","Text5"},0)),'Week 1'!A3,"")

 

[batkosta]

Excellent. Thank you very much.