=IF(ISNUMBER issues

Darkwater_Unispace

New Member
Joined
Mar 12, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hello

My first post so please bear with me. The basics of the formula is as follows:
If Cell O4 totals 0, it will return a values from A1 on tab Delta Master.
If Cell O4 totals 4, it will return a values from B1 on tab Delta Master.
If Cell O4 totals 8, it will return a values from C1 on tab Delta Master.
If Cell O4 totals 12, it will return a values from D1 on tab Delta Master.
If Cell O4 totals 16, it will return a values from E1 on tab Delta Master.
If Cell O4 totals 20, it will return a values from F1 on tab Delta Master.

They all work except the last one. When it totals 20, nothing happens.

Any ideas why? the code is below.

=IF(ISNUMBER(FIND("0",O4)),'Delta Master'!A1,IF(ISNUMBER(FIND("4",O4)),'Delta Master'!B1,IF(ISNUMBER(FIND("8",O4)),'Delta Master'!C1,IF(ISNUMBER(FIND("12",O4)),'Delta Master'!D1,IF(ISNUMBER(FIND("16",O4)),'Delta Master'!E1,IF(ISNUMBER(FIND("20",O4)),'Delta Master'!F1,""))))))
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,562
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel.
If O4 is a number rather than text try
Excel Formula:
=IF(O4="","",IFNA(INDEX('Delta Master'!A1:F1,MATCH(O4,{0,4,8,12,16,20},0)),""))
 

Darkwater_Unispace

New Member
Joined
Mar 12, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel.
If O4 is a number rather than text try
Excel Formula:
=IF(O4="","",IFNA(INDEX('Delta Master'!A1:F1,MATCH(O4,{0,4,8,12,16,20},0)),""))
OMG. you have saved me.... Thank you so so much
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,562
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,587
Messages
5,637,250
Members
416,963
Latest member
samfuge

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top