# An easy one

#### batkosta

##### New Member
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.

K.

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

##### MrExcel MVP
batkosta said:
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.

K.

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

#### batkosta

##### New Member
Excellent. Thank you very much.

Replies
1
Views
439
Replies
1
Views
207
Replies
3
Views
57
Replies
0
Views
110
Replies
2
Views
120