formula =if()

I have three columns that give in order the number of small items (column A), the number of medium items (column B) and the number of large items (column C). Each of the quantities can be anything from 0 to 999. There is a charge made for the total number of items. The charge is calculated on...

Hi. I think I'm nearly there on the IF function but not quite. I want a function that says if a given cell contains a certain text phrase, then choose a random number between x and y, and if it doesn't then choose from a different range. Does that make sense and is it possible? Thanks, Tom

I need help writing a formula. I am trying to make some budgeting sheets in Excel. I have one sheet with a table called MonthlyExpenses, with columns for Date, Categories (includes a drop down list with specific options), and Actual Cost. On another sheet I have a summary sheet which compares...

Hi, This is a problem I have been trying to solve for quite sometime. Every month I have the calculate monthly returns, (current month's price/previous month's price)-1 (or (current month's price/previous month's price)/previous month's price, either work.) I want to make this process...

Hi please help. I have the below formula but it has too many nesting levels: =IF(C4="1st",'Step 1 Materiailty Assessment'!B25,IF(C4="2nd",'Step 1 Materiailty Assessment'!B26,IF(C4="3rd",'Step 1 Materiailty Assessment'!B27,IF(C4="4th",'Step 1 Materiailty Assessment'!B28,IF(C4="5th",'Step 1...

Hi All, I can't get my head around this. <tbody> A-B-C Store %Conversion A 9,2% B 7,50% C 9,0 </tbody> So I have my A-B-C store and the expectation are different for all of them in terms of condition. Right now, I'm doing manually, but I'd like it to be automated. So when I enter the...

Hi I have input these formulas in Columns But they Show results when the references cell is Empty 1. Column A : =COUNTIF($B$1:B197,B197) 2. Column C : =B199*1000+A199 3. Column G : =TEXT(WEEKDAY(F199),"dddd") 4. Column J : =I199-H199 5. Column L ...

I have a couple columns (N, O, P, Q) which hold numbers. I want to check if any cells in these columns are empty. And if they are, I want Excel to somehow indicate them which ones they are (highlight the cell or the record, preferably). I have a formula in mind...

Hi, I've been banging my head against a wall with this and I'm reaching out to the internet for some wisdom and help. I have a basic spreadsheet that shows a request for the cover of hours which is then either then picked up by Group 1, Group 2 or Group 3. What I need to do is show in the...

Hello, I am trying to create an IF statement for column H to determine an available time for each client. In column H, I am only looking at the preferred columns (B,D,F). If there are more than three duplicate times per column, I want column H to return with "Look at Preferred Options" so...

Hi, i have huge date contain text/number/combined devises. sample data as below A B A2 21411111 A3 21412232 A4 24600221 A5 24600000 A6 2K221212 A7 2K221213 A8 2D221213 A9 2D221212 A10 71717777 A11 3458 A12 3587 I wanted to get the devises model, result should...

Hi, I have 1 column where the total number is, and I have 5 other columns where that number could end up, depending on the number column 1 --- less than 75 column 2 --- more than 75 and less than 150 column 3 -- more than 150 and less than 300 column 4 -- more than 300 and less than 400 column...

I need some serious help I need to create a date calculator but I need to exclude certain dates only if the end date falls on that date. For example, 1/2/15 and add 15 days... but here is where I am stuck... Only if the date falls on a weekend or federal holiday I need to skip to the next...

Hello, I have been having some difficulty for a few days now with this issue. I am attempting to find the Max for an age based on multiple criteria some excluding and including certain texts from the cells. I tried building it like the countifs statement where you can search for certain...

Excel for Mac 2011 Version 14.5.4 I've got a scenario where I'm trying to write an if/or function. Here's what I have so far: =IF(OR(C43=0,C44=0),0,IF(OR(C43<61,C44=1),0.05,IF(OR(C43>120,C44>4),0.15,0.1))). The logic is: if C43 is between 1-60 or C44 =1, then the discount is 5%. If C43 is...

I only want to average the values that would be left in Column M, if you removed all except the ones where the sign of the value in L changes from that current row to the next. {{EDIT: "and the absolute value in "L" for the current row is not 1 or -1}} Thanks so much for your help and esp...

=IF([TimeSheets.xlsx]Tim!B12="_r2500",(SUM('[TimeSheets.xlsx]1st:Last'!$E$23)),"0.0") This works as expected; however, I need to expand the "Tim" worksheet to include 1st:Last. (When I attempt this, I receive a #REF error.) I don't understand why 1st:Last works in the SUM, but not in the IF...

Hi, Can anyone help with the correct format for using MEDIAN IF and (I THINK) AND formulas? Essentially i want to calculate the median based on multiple 'if' statements. I can get it to work for one 'if' but not any more... {=MEDIAN(IF(A1="10" ............ , $AD:$AD))} How do i add more IF...

I would like to set up an IF statement in excel and need some assistance. Scenario: I am tracking commissions between two real estate agents. If one of them was the primary seller, they get 60% of the commission. The other agent gets 40%. What I want to do: If "A" (first initial of agent's...

Hi - apologies, as I'm sure this thread has been rehashed hundreds of times, but I searched through a few of them and none quite solved my problem as it currently is (most are attempting to solve the reverse...) Essentially, I want to tell the spreadsheet that if any cell in Column B is filled...