An easy one

batkosta

New Member
Joined
May 27, 2005
Messages
33
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.
 

Some videos you may like

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).

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
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.


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,"")
 

Watch MrExcel Video

Forum statistics

Threads
1,119,142
Messages
5,576,318
Members
412,716
Latest member
thviid
Top