Ok so I have this formula and it works, however I need it to do a bit more and cant figure it out
=IF(S99>2400,13%,8%)
so S99 is a cell with an average of money made after so many sales and if sales are an average of $2400 or higher it equals to 13% commission and if not it equals to base...
Hi Excel Gurus,
I'm trying to write a formula in my report as below, but it only returns error "#VALUE!".
There are the scenarios:
If the value is a number or contains "-", equals L12
If else, leave it empty.
=IF(OR(ISNUMBER(E12),FIND("-",E12)>1),L12,"")...
I'm using the following SUMIF statement: =SUMIF(G10:G22,"x",F10:F22) and it's working perfectly.
Now what I need in cell U10 is a formula that will look at cell G10. If the value is "x" then U10 will display the value in cell E10 ----- AND ----- at the same time I need it to look in...
I have a table with two year columns: Current_Year and Future_Year.
I need to SUM the amounts where Future_Year equals Current_Year, but exclude records where Future Year equals Current_Year.
Using the Data below, if Year 2000 is selected on the Current_Year slicer, I would need it to SUM...
i think what i am trying to do is pretty simple but i cant figure it out. Basically i have two totals i want to add....so =A4+B4
Sometimes B4 will be blank but i still want to show the value of A4 with this formula.
So in some cases =10+20 equals 30
in other cases =10+(blank value) equals 10
Hello,
I am curious about something. Is there a way that I can reformat columns based off of their headers? So for example, can I create a MACRO that says,
If Header Equals UPC (That is, "UPC", "Upc", or "upc") than reformat the entire column so it is formatted as a "number" format as...
Hello all,
I have a formula as below working very well I just want it shortened and clean if by any way possible. It is self explanatory still I can explain if required
Basically If checking from M column if right 3 words equals Bel and AB is equals or less than 72 hours it will be writing...
I am trying to compute the downtime and have a formula that subtracts the on task time, transit and wait time from 24 hours. However if the sum of the calculation equals 24 hours then I get #####s in the cell; if it equals 00:00:01 then it will display correctly ie 00:00. Is there a way of...
Dear Team,
I need one favour from you i want to find out the combination of numbers that equals to target value.
by using excel formula i tried but cant find the solution.please help me out ITS BIT URGENT.
<colgroup><col style="width:48pt" width="64"> <col...
Please help!!!
Formula to go in cell AR2....
I need to look up the contents in AP2 in column AP and count the associated unique job numbers in column S. I would also like to add the condition that column A equals "CCAP". Is this possible?
Hopefully this makes sense... I am cross eyed at...
Hi there,
I have a Sheet and would like to only display certain information if the cell C118 is equal to 0 (if equals to 1 then I would like to hide automatically rows 68 to 77
Can you help, not really having advance knowledge on VBA
Thanks,
Hi
I want to run some VBA when a cell equals a certain value, for e.g. A1 = 1.
I've looked around the net and found code examples using but can't get it to work
All help appreciated
I am trying to write some vba code to be able to do the following:
If cell p9 equals True, then B10 equals OFF.
I have tried
If Sheet2.Range("B9").Value > "" And Sheet2.Range("P9").Value = "TRUE" Then
Sheet2.Range("B10").Value = "OFF"
I have made P9 equal True and I...
Hello All,
Im running into an issue where my IF() statement is incorrectly calculating the formula. For context here is the formula:
=IF(SUM(O38:O54)='4 Sources & Uses of Funds'!K48,"OK","CHECK")
As mutually exclusive formulas, SUM(O38:O54) absolutely equals ''4 Sources & Uses of...
Hey Guys,
I am new to this forum and need help with excel formula to calculate Up, Down & Stable figures.
A B
4 4
3 4
7 6
What I need is,
If figure in ColB>ColA = Result should be "Down"
If figure in ColB<ColA = Result should be "Up"
If figure in ColB=ColA = Result should be "Stable"
I have...
I have (2) sheets,
Sheet 1 contains all of my data with Col. B listing types of skincare products.
I have (2) conditions I'm searching for in Col B:
If Col B contains (or equals) "Lotion" I need to look at the brands in Col C, then perform a VLOOKUP which tell assigns a type to the lotion...
Hello, thank you for considering helping me with my problem.
I would like and appreciate a function that does the following for my work.
A function that enters the following values into a cell if the cells it is referencing meets a criteria.
1 if C2 is blank or zero
2 if C2 is 9 or more less...
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.