Hello, New to this site so apologies if this has been covered before and I just don't know how to search for the answer.
I want to use conditional formatting to make blank cells yellow in any/all columns if there is text in column A.
For example, column A could be order numbers, column B could...
I've set the below formula. It works great when Activity 1-3 have been selected for Pass/Fail.
=IF((AND(D20="Pass",D21="Pass",D22="Pass")),"Pass","Fail")
However, if the Activity section hasn't been filled out yet (or are blank), the Outcome in B35 - B37 default as "Fail"
If the criteria...
HI,
Newbie to excel here.
I am trying to use code to take a named range on an invoice and add it to a database in a separate sheet.
The code I am using is below but need it to not pull any blank cells that contain functions in them.
Code I was previously told to use but has an error...
Hi.
I have data in range from Columns G to R. I have value "a" at column J and then 2 Empty Columns. After them I have data at column M and formula give me value "d" but I want to be "b". Also for Column Q, I have "h" but I want "c". If I have Data, this is my formula at Column M( change Column...
In one column I have a date field. If there is no date I don't want the other columns to calculate the formula, using VBA.
Column c: 1/20/20 Column D: "formula is column c +21 days column E: "column d minus today.
its all based on the date field in column C.
Hi
I have the following formula in a cell, which works great, and turns what is in the cell blank, if a 0) is subsequently put into cell a23.
However there are times when I then need to then change cell a23 back to a different number, so I then want the formula to kick back in ......
Problem...
Hello,
Currently having some issues when copy/pasting some range of rows.
There are some formulas in there that would be populating depending of another table.
So in the end there would be some rows populating from such table, and eventually remaining rows without populated values would remain...
Hi. This is my first question sorry in advance.
So I hae two clumns C and D, D is my expiry date column and C is my start date column. I have formated D to turn orage or red depending on the time left. I also have the formual =EDATE(C3,6). The problem s that because nothng is acctually entered...
Hi all
Probably a very simple answer, but I have a series of SUMIF cells which all work perfectly, until they reach a blank cell which contains a formula. I can't find the right syntax for the SUMIF to work, any ideas? The code at present is:
=SUMIF($AI$2:$AI$328,"",$AD$2:$AD$328)
Where...
Hi Everyone, first post here. I couldn't find anything on it. I want to have a running total of two columns showing in a third column, which I was able to do with the following that I found in another post:
=SUBTOTAL(109,$D$3:D9, $E$3:E9)
my problem is that after my last row with data, it...
Creating a title for this was tricky. So I have a spreadsheet in Google Sheets where I have three sets of data that I need to add together but there are times one or two of the cells might be blank. Basically, I am trying to create a Score for a call center rep where a call is worth 8 points...
I have created a graph to show readings over time and I use the option to skip over empty or blank cells.
Problem is that my formula to create empty cells is not creating truly empty or blank cells.
The example formula is =IF(A1=3,A1,"") ... The =IF statement checks cell A1 and if it finds...
Hello, I am trying to figure out a formula that will help me populate cells based on the sample instance below. I've tried different IF statements but can't seems to get it to work right. Any help is greatly appreciated. Thanks!
<tbody>
Name (current)
Name Populated All the Way down...
Trying to setup a closing date calculator. The formulas are easy and are working fine, but when I convert this to be added to a website, it populates a date with year end '00 in A7 & A13. How can I make the cells show as blank until until A3 and A10 have values selected?
Select Contract Date...
When I copy this code to the cells below it, IF the reference Cell is empty it puts dates in all the cells (exp. 1/1/1900) how can I safely Convert these formulas into the IF CellBlank Fomula?
HERE IS THE FILE : http://www.filedropper.com/accrualscalculations
Hello to everyone on this forum! I am so glad I found this because I am pretty stuck. Here is my problem:
I have a list of names on one excel sheet, I have a formula that takes whatever name is typed into a particular cell and checks the number of times that particular cell appears across a...
Hey guys,
I need some help with the If function in VBA.
I need to put a formula in every empty cell in a specific column and I can't manage to define the function.
My code is this (but it doesn't do anything):
For Each cell in Worksheets("Sheet1"). Range("L5:L" & Rows.Count.End(xlUp).Row)
If...
PROJECT DESCRIPTION:
I am making a time sheet. Rows 32 and above list the hours I have worked in a day. Each row represents a day. Each column represents a different castigatory (vacation time, hours, overtime, sick time, etc.). Row 34 lists the $ I earn for each category. I am using column M to...
Hello everyone!
mrexcel has been my top resource when it comes to Excel-related questions. Great to be a member now.
What follows is a tricky combination (for me, that is) of
- starting from several rows named "A", "B", ... with blank cells, zeroes and values larger than zero in columns named...
Hey everyone, this is my first post!
I've figured out how to create a dynamic chart, where the last values of my data are forced to be blank using an IF formula. The range that I created for which this works has the following formula...
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.