1. PuntingJawa

    Shorten IF formula with multiple conditions and =If(or() for second part

    I'm trying to shorten my formula if possible for a manual load planner. I have 2 types of formula that I am trying to modify. 1. =If() I am trying to shorten if possible for "Basic setup 1st row" and "3rd row" area. 2. =If(or() I haven't quite figure out how to accomplish for the "Basic setup...
  2. suzid123

    IF / SEARCH function not progressing to next condition?

    Hi, I'm almost certain I'm using the wrong search function. Apologies, my work computer doesn't permit me to install XL2BB. I have one list which has classes and their status in the program. The possible statuses are: Active Confirmed Pending Exploratory There are multiple classes per school...
  3. H

    Conditional format custom formula - IF(AND from range

    I have a range of dates: K9 = 01/01/2021 K10 = 02/01/2021 K11 = 03/01/2021 K12 = 04/01/2021 K13 = 05/01/2021 I have 5 conditional formatting rules: =IF($B19="PRE",AND(K$9>=$H19,K$9<=$I19)) =IF($B19="PRE",AND(K$10>=$H19,K$10<=$I19)) =IF($B19="PRE",AND(K$11>=$H19,K$11<=$I19))...
  4. F

    Names on two different sheets, trying to look up value

    I have two sheets with names on them. One has just names (names of sales people who just made a sale) and the other has the names of sales people with the amount of sales they had over the past 12 months. I pull data regularly to see who the most active sales people are. I want to be able to...
  5. M

    Excel Check Employee Rates

    Hello! I have a spreadsheet I use for creating invoices for our clients. We have formulas that calculate the raw rate (showing employees rate before any profit multipliers are applied) for each line. This is part of our checks and balances process for our client, as they look at the rates for...
  6. G

    =text remove 0.00

    Hey, Fairly new to this so any help is appreciated. We use excel to run graphics on a OBS System for a money exchange company - issue being OBS only likes to use "text" formatting, not number, currency or even general. We show a lot of currency on the the screen that we copy from various...
  7. M

    Can this complex rate-of-return formula be simplified?

    =IF( ROW()-ROW(Table1[#Headers])<12, NA(), (1+INDEX([Monthly RR],ROW()-ROW(Table1[#Headers])))* (1+INDEX([Monthly RR],ROW()-ROW(Table1[#Headers])-1))* (1+INDEX([Monthly RR],ROW()-ROW(Table1[#Headers])-2))* (1+INDEX([Monthly RR],ROW()-ROW(Table1[#Headers])-3))* (1+INDEX([Monthly...
  8. T

    =IF (CELL iS Highlighted) then...

    Is there a formula based on highlighted cells? Example If cell A1 is highlighted in any color, then B1=100 Many thanks!
  9. R

    If Statement for Time Range Help

    I'm needing help with as time range IF statement I'm working on. I have in Row 1 (starting in Column D) time listed out in 15 minute breaks starting at 6 am. It is in military time currently. (06:00, 06:15, 06:30, 06:45, 07:00.... 23:45, 00:00, 00:15....) In Column B2 I have the start time...
  10. K

    Alternative to ifs function

    Is there another option if you can't use the =ifs command other than using multiple & if over and over? Thank you!
  11. tryingcake

    =if, then answer needs to be a number, not text

    I need to run a formula similar to this: =IF(C58<0.06, "2") My issue is, it's reading the "2" as text. I need it to be a number than can be added to other numbers. I can't find the correct formula. What do I need to do differently? Thanks!
  12. R

    To Excel Pro MVP's

    Hello Guru's ALT + ENTER and some spaces NOT IN VBA! What are the disadvantages of this neatly coding in Excel formulas, aside from I have to manually type the spaces? =IF( COUNTIFS( P23:P40,">="&NUMBERVALUE("04/01/2019")...
  13. B

    Help with repeating formula automatically adjust cells

    I really can't word this well, so I'll explain what I mean. I have 2 sheets, the first one you manually type things and the 2nd formats it into a certain way. The first sheet is setup vertically with names being the rows, and the formatted sheet has the names as the columns. To format the 2nd...
  14. T

    Auto populating empty cells with specific text selection from drop down list

    I am trying to auto populate a group of empty cells with specific selections from a drop down list. The total list contains five entries, two of which I want to populate the empty cells when they are selected. I have tried the =IF formula, but it only seems to work within the same sheet...
  15. M

    If Statment within an if statement

    So I am having trouble with my if statement. My logical test is if G19>40, If its true I want it be F19-(G19-40), however if F19-(G19-40) is a less than 0(or negative), then it needs to read"0" if false f18. HELP!
  16. A

    Formula to return a value where the reporting month matches on two separate worksheets

    Hi there, new member here.... Looking for some support on creating a formula to return a value where the reporting month matches on two separate worksheets. SHEET1 cell L5 is where the formula will go. I want the formula to change the response depending on which month is typed into cell F5...
  17. Y

    No Blank formula (oposit ISBLANK)

    Hi. Is there a formula that i can use part of =IF / =IFS (the cell is not blank). As there is =IFS(ISBLANK(A1). E.g. =CONCATENATE(IFS(ISBLANK(A1),"",(the cell is not blank(A1),"YES")
  18. M

    Help with formula to add addtional rules. IF formula

    I’m trying to come up with a formula to handle multiple situations. Current formula: =IF(Indiv!C5<8,Indiv!G5,Indiv!B5). current formula will return “227” with example below: <tbody> Cur Ave Gms Total Pins High Gm High Series Ent. Ave 201 4 804 217 804 227 </tbody> C5 =...
  19. P

    =if() function is not working like it should be

    Any formula that starts with =if() doesnt work. What should i do?
  20. M

    addition of =ROUNDUP, causes function to become 'text' in formula bar

    Hi all. I have a function below which compares two values to two reference cells and works as expected: =IF( OR( AND( AL33 >= $AW$15, AM33 < $ AW$15), AND( AL33 >= $AW$17, AM33 < $AW$17) ),"Y","") However, when I add =ROUNDUP in the formula it isn't recognized as a formula, and instead becomes...

We've detected that you are using an adblocker.

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.
Go back