=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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,468
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,468
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,403
Messages
5,636,080
Members
416,896
Latest member
Hozier

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