Hi,
My query is I want column D to look at F3 and also check the time as per colums C to deliver a specific number.
So in D3 I have the following - =IF($F$3="","",IF(AND(C3<$C$10,$F$3="Standard"),2,1)). So this is checking the time is before 07:30 (Column C) and Standard is in F3. I want to add...
A1 (Fee) = $ Value
A2 (Lodged) = Yes/No
A3 (Type) = Multiple choices
A4 (Risk) = Yes/No
A5 (Option) = Fee Waiver
This IFS function does works but I would like to use an IF function so that rather than an #N/A response for False I would like "Declined"
=IFS(AND(A1<=30,A2="Yes",A3<>"Dishonour...
I'm trying to make a formula that basically says if this number (4.57) is between B and C, then pull in A. Since there is more than 7 options, a regular IFTHAN statement won't work. I just can't think anymore and need help.
<colgroup><col><col><col></colgroup><tbody>
A
B
C
0 - 6 mo
0
0.5...
Even with all the help I've received on this forum, this code is practically finished, but I'm getting the "LOOP WITHOUT DO" error. And I know what that means, I just don't know where in the code the error is being triggered. There are literally no articles I can find commenting on this many...
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:
<tbody>
<tbody>
DISTRIBUTION...
Hello,
I would like some help in creating a button macro for a spreadsheet that is essentially a user form. The form has four cells in which the user enters requested information in cells B6, B8, B10, or B12. Not all of the cells require a number. When the user clicks on the button, I would...
Hi all,
I've created a spreadsheet for work to show job completion dates. I have 3 columns with the following headers:
Job Completion date
Job Deadline date
Overdue?
I want a formula that can show whether a job is still on time or overdue, but also returning text saying "Not yet completed" if...
Hello Excel experts,
I am new to excel VBA, I have a query using multiple IF statement and copying the result on another sheet, I tried Vlookup also, however nothing worked because there are multiple columns in 2nd sheet with the same name and different ColumnD, it looks code checks the first...
Hello
I believe I am on Excel 2007-2010 version.
I am looking for guidance on creating a formula which can produce a result of 3 categories.
I have a list of querys which all have the amount of days aged against them from receipt. In my spreadsheet this is Comlumn L. I would like to create...
Hello!
I have almost finished my spreadsheet project that I was working on, yesterday. I've hit one final snag, though. I need to auto-populate a couple of dates that result from calculations and multiple IF statements, and I would VERY much like to combine all of these conditions into one...
A B C D E F
<colgroup><col span="6"></colgroup><tbody>
Goal
Stretch Goal 1 (5)
Stretch Goal 2 (10)
Stretch Goal 3 (15)
Actual
Store 1
19
20
21
22
25
Store 2
29
31
32
33
35
Store 3
8
9
10
11
16
</tbody>
The End Result Needed:
If...
Sorry if I don't explain this very well, I'll do my best-
I need a formula in B1, which will check the date in A1 and tell me if it is within this week's dates. It will say 'This Week' if this is true. (eg. if A1 says: '30/12/2014' (or any other date from the current week) then it will say...
Hi There,
Is there a way in VBA to use an IF statement and have multiple checks? So for example if I wanted to check a cell value for one of several string segments, could I do that with one if statement? I could do multiple ELSEIF statements or multiple CASE statements, but I thought it would...
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.