Hello, I am trying to use =Excel.Workbook() to list all of my sheet names. I see the syntax:
Excel.Workbook(**workbook** as binary, optional **useHeaders** as nullable logical, optional **delayTypes** as nullable logical) as table
But for **workbook** how do I say "this workbook" without...
Good day to you all,
I need help. I am trying to create a column for late fees, if either Registration Date (C) or RX received (D) are LESS than 30 days from Camp Start date (I). Basically if we receive either the registration or the Rx less than 30 days from camp session start date I have to...
Can someone please help me, I've been stuck on this for so long.
I need to use a formula to create a conditional formatting rule that will format the values in the selected range in the dark red font color if the employees have worked overtime hours. Using relative referencing in the logical test.
How do I create a formula using an operator chosen from a data validation drop down list. For example: if in part of an array formula I have a logical test of $A$2:$A$50>=$B$1 and I want to be able to change the >= to <= or another by referencing a data validation drop down list in cell $C$1...
I am looking to create a SUMIFS using multiple criteria; not sure if what I am attempting is possible, any and all help is appreciated. Below is (to me) what would seem the logical formula, however, it is returning a incorrect sum. Thank you in advance...
I need help with creating a formula with two logical tests. I got the first one but can't figure out how to include the second logical test.
I also need to add to this formula that if M40="6%" than times 106%, if blank N40. I tried adding a second IF, using AND function but not getting what I...
Hello
I have a column with logical values (true, false). I used countif command to count the number of those cells, but the outcome was zero..
The command I used is:
=COUNTIFS(R2:R5433;"TRUE";R2:R5433;"FALSE")
I also wrote the above command without the second criteria (for false) and I got...
Good evening peers,
I am trying to figure out a logical way of deleting the highlighted rows in RED on the attached example workbook.
the data is variable so it can change location and im trying to determine what logical approach i would take to delete the unncessary rows generated.
I have...
Hi all,
I'm looking to filter data and have the displayed results averaged in a column header. Between the data and column header I have the filters. I'd like the totals at the column header to take into account only the data being shown below. There must be a really logical way of doing this -...
Hi,
I'm having a hard time in trying to simplify my IF formula without restating the logic if the value was not achieve.
Say I'm trying to get the difference between years then add one and if the answer is 5, then it will take 4 instead of 5 so I'm using below...
Could you please help over this formula where I need to have separate logical test where if two certain cells contains special text like medium or high an x should be replaced in other certain cell
formula is like but not working...
Hi
What is the best way to convert numbers to grades. For example
0 to 50 is F
50 - 60 is C
60 - 70 is B
70 - 80 is A
80 - 100 is A+
What is the best way or formula to do so. I was thinking of If() with logical operations like AND, OR etc
Any idea would be very much appreciated. Thanks
Hello!
I'm sorry if this question has been answered elsewhere, though I couldn't find it if it had.
I'm using a logical formula that returns a number value based on whether the condition is true or not. The formula is like this: =IF(A1>A2,A2/A1,A1/A2) and works fine for me.
I want to use...
Hello All,
I'm not very good with Excel at all and I need help in creating a logical formula with more than one value. I appreciate any help :) Thank you !
It goes like this:
If anything in E2 through E101 is "1", and anything in F2 through F102 is 'JR", and anything in G2 through G102 is...
Hello!
Here is my formula..
=IF($A$2>DATE(2017,MONTH(L$3&"/1")+1,1),0,($D78-L76+L77))
A2 = today's date
Column D = stock
L76 = monthly forecast
L77 = deliveries due in month
L78 contains the above formula & as is referred to as the 'availability'
So basically if the month is in the past the...
Hi - so I have this sheet for work. I need it to do a few things and I can't seem to do it
I have the formula to populate my weekly dates using my EE Assigned initials based on the Begin Task and Task Deadline date ranges
What I can't seem to do, is to get a nested formula, or conditional...
I want a formula associated with IF using
in E6 I have a negative or positive currency number, and in F6 I have another negative or positive currency number
I want to formulate in G6 if E6 is equally or less then have of F6 should resulting Good if not should resulting 0
for example F6 is...
I have a program for a charitable gaming calculator but don't understand exactly what the formulas do. There are six entries per 'race'. The formula is:
IF(TRUNC((total bets all 6 entries/2)/bets on this one entry)=1,2,TRUNC((total bets all six entries/2)/bets on this one entry))
I...
I have a fluctuating data in column A:A, a Fast MA in column B:B, Slow MA in C:C.
I'm going to start with the first formula to compute in Column E:E, which
1. needs to display a prior value repeated at least 3 times consecutively (not in order of occurrence just needs to be in the formula...
I have a VBA conditional function I hacked together (I'm a noob) that does a hex 'AND" function on a 36-bit value in a cell with another 36-bit value.
This result is then passed though another function (total hack) that looks for logical '0' other wise it assumes logic '1'. The second part is...
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.