Absolute VBA beginner here. I have been researching to find out how to do the following but to no avail.
I have created a book with 12 months which has columns containing data.
Please see snapshots I have added. New entries are being added to these lists via index match formulas...
I have a spreadsheet at work that the techs enter in on/off times for equipment. I need to know how many hours the equipment has ran that day.
OFF ALL DAY?
ON ALL DAY?
INITIAL SHUT DOWN
INITIAL START UP
SECONDARY SHUT DOWN
SECONDARY START UP
i have a table with 4 columns.
col1 col2 col3 col4
Please help me with a formula that outputs the following:
col1=empty & col2=empty & col3=empty & col4=empty => output a
col1>0 & col2=empty & col3=empty & col4=empty => output b
col1>0 & col2>0 & col3=empty &...
Hoping some advice as I am not sure whether to use Excel or Access (I'm better with Excel than Access) to auto populate a cell based on multiple tables. I'll explain how I thought it may work in excel - I just want to see if this would be easier/better in Access or indeed if there is a...
I'm creating a spreadsheet to detail the fire door ratings based on the fire strategy and a physical survey. A straight forward exercise where the door is not fire rated (NFR), fire rated for 30/60 minutes (FD30/FD60) or fire rated for 30/60 minutes with a smoke seal (FD30S/FD60S). I want to...
Please could someone help me with an IF statement. I would like to write the below in an IF statement if possible.
Total number of items = 39
For each item that is failed, 0.01 point deducted per 0.01% that the item is below 99.5% but above or equal to 96% and
For each item...
I am currently making a macro for a button to log queries, I tried to use an IF statement to check if the desired cell is empty, and if not, record the comments on the next cell to the right but it doesn't work, please any help would be much appreciated. See below:
I have a table with hospital admission date (column A), discharge date (column B), and a third column that calculates the duration of stay (column C).
Sometimes, people forget to enter data for either the admission date (column A), or the discharge date (column B), or both (columns A...
I am hoping somebody can suggest a simplified version of what I currently have.
I am tracking time spent on a project by other team members and have an extremely over complicated way of working out the costs.
I created a user form for inputting the hours to make it simpler for the team and...
I have code below, works fine but notice the if statements and how it loops through two worksheets separately but ultimately does the same thing.. any ideas / advice feedback on how to make it more efficient if possible? I'm pretty new to VBA so this was the only way I new how to do this. Thanks...
I'm using this formula: =IF(D10>29,$D$3,IF(16<d10<29,$d$4,if(d10<16,$d$5)))
For the 1st and 3rd 'IF' logic statements, the result is returned correctly. When the second logic statement is met, the result is 'False'. The table shows what I'm trying to do:
Hello everyone, Thank you in advanced for your help.
I would like to have a macro run when a workbook is opened but only if the current date of a cell doesn't match up with the system date.
What I have
Private Sub Auto_Open()
Application.ScreenUpdating = False...
I am trying and struggling to create a nested IF statement for risk assessment that works this way:
The risk factor is calculated by multiplying the consequence(ranges from 1-7) and probability(ranges from 1-9). Based on the product of the two the values can be categorised as very low...
I have a formula that pulls two columns of time together into a third column. The formula is in Column S and is:
lower(TEXT(Q2,"h:mm AM/PM")&" to "&IF(R2="","",TEXT(R2,"h:mm AM/PM"))))
(for example if both columns are not blank, this generates "6:00 pm to 8:00 pm")
I have an excel database of survey information that returns the 1st, 2nd, and 3rd lowest values using SMALL formula, but I applied an IF formula on the spreadsheet to return the statement that value is tied to. However, if the value is the same it returns the same statement twice, rather than...
Could someone explain what is wrong with this formula....
=IF(AND(C247<2,E257>0,IF(C247<3,E262>0)),"Please ensure all irrelevant options are blank","")
The first part works [BOLD] but the second part doesn't.
I'm not sure exactly why they cant work in conjuction?
I have searched far and wide for a solution to this and spent hours trying to figure it out, and I am now admiting defeat and hoping someone will be able to help me.
I have the following type of data: