Results 1 to 9 of 9

IF(OR(ISBLANK( formula not working

Threaded View

  1. 01-12-2021, 10:49 AM #1
    Ramirez07
    Ramirez07 is offline
    Registered User
    Join Date
    01-12-2021
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    18

    IF(OR(ISBLANK( formula not working

    I have a formula looking up a month name in cell BT3, once cell BU3 reads a month name in BT3 a formula needs to retrieve the data in cell F3. If cell BT3 is blank then BU3 must also be blank. The months is in a array "MTH" which are from January...December.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. OFFSET / ISBLANK Not Working in Array Formula??
    By Merf in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-23-2020, 10:02 PM
  2. IF(ISBLANK) formula not working.
    By ezidz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-19-2020, 01:35 PM
  3. [SOLVED] Isblank not working when formula is inputted - what instead of?
    By jaryszek in forum Excel General
    Replies: 11
    Last Post: 03-20-2019, 03:45 AM
  4. Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-17-2017, 12:26 PM
  5. [SOLVED] ISBLANK Formula Kind of Working
    By jetamala in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-16-2016, 03:41 PM
  6. [SOLVED] IF formula not working =IF(NOT(ISBLANK(M3)),"",IF(ISBLANK(L3),"",TODAY()-L3))
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2014, 02:37 PM
  7. Help with ISBLANK function referring to a cell with another ISBLANK formula
    By camdameron in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-23-2011, 12:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1