Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-05-2023, 10:09 AM
daviddyer2902 daviddyer2902 is offline Trying to use function =if(isblank(**),"",1) but it doesn't seem to work on the columns Ihave listed Windows 10 Trying to use function =if(isblank(**),"",1) but it doesn't seem to work on the columns Ihave listed Office 2019
Novice
Trying to use function =if(isblank(**),"",1) but it doesn't seem to work on the columns Ihave listed
 
Join Date: Mar 2023
Posts: 1
daviddyer2902 is on a distinguished road
Default Trying to use function =if(isblank(**),"",1) but it doesn't seem to work on the columns Ihave listed

I am trying to list “members” with various Grades from 1 to 8, but, I then want to know who is ready for advancement, say from 2nd to 3rd Grade.

I have attached the file and hope it gets to you in one piece.



If, when opened you go to the 1st Mons Tab and on to col Y to BL.

Col Y to AV records where the candidate undertook his 1st to 6th Grade with the date of the ceremony worked.
Col AW to BD are the result of an =if(blank(cell no.),””,1) function which will leave a corresponding “1” or blank in the respective cell, depending if the argument is true or false.
The function =Countif(array) will then add up the number of 1s in the column.

Col BE to BL are the inverse of the cols AW to BD in that they are supposed to display by showing a 1 or a blank. Such that if a candidate has achieved a 2nd Grade then the column BG would show a 1 in the 3rd Grade column and columns BH to BL would show blanks in that particular row.

So, columns AW to BD show the grades achieved.
Columns BE to BL show the very next grade to be undertaken.

The problem is that using the function “=if(isblank(* *),””,1) on columns Be to BL doesn’t return the expected result.

You can simply delete the 1s in cols Be to BL as they are only illustrations of the results I should expect.
Attached Files
File Type: xlsx club Losses and Gains Sept 1st 2022.xlsx (462.4 KB, 7 views)

Last edited by daviddyer2902; 03-05-2023 at 10:11 AM. Reason: simplify the question
Reply With Quote
  #2  
Old 03-06-2023, 02:24 AM
Debaser's Avatar
Debaser Debaser is offline Trying to use function =if(isblank(**),"",1) but it doesn't seem to work on the columns Ihave listed Windows 10 Trying to use function =if(isblank(**),"",1) but it doesn't seem to work on the columns Ihave listed Office 2016
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

Your workbook layout doesn't appear to match the description in your question. It's also hard to determine why a formula isn't working if it's not in the workbook so that we can see how you tried to use it...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro Matt C Excel Programming 2 01-08-2022 06:03 AM
Conditional function to operate a formula based on "Yes" or "No" Condition Des ONeill Excel 1 07-03-2021 12:17 AM
"Uppercase" in Master Layout doesn't work in actual slides BDesign PowerPoint 2 07-03-2019 07:06 AM
Trying to use function =if(isblank(**),"",1) but it doesn't seem to work on the columns Ihave listed Why the "table of contents" doesn't take the same format of the "headings"? Jamal NUMAN Word 5 06-15-2011 10:14 AM
Outlook- "Type A Contact To Find" Doesn't Work jill5545 Outlook 0 11-14-2010 08:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft