=if

To be specific: I need cell B8 to show the value of cell D100 only if cell B3 is equal to a special value (17), OR show value of cell K100 if equal to a different specific value (29)

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

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

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))...

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

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

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

=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...

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

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

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

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!

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")...

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

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

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!

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

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")

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 =...

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