# 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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
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,"")

Excellent. Thank you very much.

Replies
4
Views
418
Replies
12
Views
430
Replies
3
Views
222
Replies
7
Views
270
Replies
4
Views
284

1,207,090
Messages
6,076,520
Members
446,211
Latest member
b306750

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back