if function multiple

In cell A1 I insert the date In cell A2 I have the command =CHOOSE(WEEKDAY(A1),"SUN","MON","TUE","WED","THU","FRI","SAT") In cell A3 I insert the worker IN time and in cell A2 the out time ( in mm:ss AM/PM format ) In Cell A4 I need the following results, can anyone please help me with the...

Hey guys, I'm currently creating a room registry and encounter this error in one of my if function :error #value I tried to googling this issue but failed without luck. <tbody> type of room no.of night extra bed room price complimentary total </tbody> 1. under number of...

I need a little help with what I thought would be a prettysimple if function; however, the solution seems to allude me. I have 3 columns. Column H is going to generate text (“Yes”or “No”) based on what’s in columns I and J. Columns I and J are for dates someone is certified in aparticular...

Hi everyone, I have the following table: <tbody> Type Min Max ID % Fees Office 0 50 1 3% Office 51 150 2 4% Office 151 300 3 5% Retail o 150 4 3.5% Retail 151 500 5 4.5% Retail 501 1000 6 8% Other 0 1500 7 5% </tbody> I have : Office type with $150, the formula should returns...

Afternoon everyone, Been working on this now for about half a day and can not work out why it is not working. The Plan was if F9 is equal to Alpha and W9 is between P1 and Q1 then subtract Z3 off X9 if F9 was not equal to Alpha and is between T1 and U1 then subtract Z4 from X9...

Hello All firstly thanks for looking to see if you can help me; Problem: I want to work out how many staff i have working per hour. so across the top i have the hour window, along the left i have staff names with what hours they will be working. as below: <tbody> A B C D E F G H I J K L M...

So I've got a big stock spreadsheet with multiple tabs to seperate catergories and within each tab is a table. each containing items, each with multiple sizes and then the quantity etc. for example one group of items I have is <colgroup><col span="2"><col></colgroup><tbody> Item Code Size...

Hi All, I am trying to write an if function for the below. <TBODY> Option 1</SPAN> Option 2</SPAN> Option 3</SPAN> Option 4</SPAN> Option Cost</SPAN> Y</SPAN> N</SPAN> N</SPAN> N</SPAN> =IF(A2="Y",'Costs '!D24,"")</SPAN> N</SPAN> N</SPAN> Y</SPAN> N</SPAN> N</SPAN> N</SPAN> N</SPAN>...

Hello all, I apologize but I cannot download the html creator while at work due to IT locking that function down so hopefully I can describe my question in a way that makes sense. I am trying to create a formula that checks if a single cell date falls between a beginning and end date using the...

My Scenario is as follows:- If the Value is >=1, <=2 then the value will be 4.5 If the Value is >2, <=4 then the value will be 4.5 If the Value is >4, <=7 then the value will be 80% If the Value is >7, <=9 then the value will be 60% I tried the following Formula:-...

Here's the thing: I'm making a list of all threatened species found in Conservation Units of Sao Paulo (Brazil). There are a few categories that species can be included when we talk about their conservation status: - EX (Extinct); - EW (Extinct in the Wild); - CR (Critically Endangered); - EN...

<tbody> Date Round Home Team Home Score Away Score Away Team 13/09/2013 1 TEAM A 1 1 TEAM B 12/09/2013 1 TEAM C 2 1 TEAM D 20/09/2013 2 TEAM C 1 1 TEAM A 27/09/2013 3 TEAM A 2 1 TEAM D 05/10/2013 4 TEAM C 2 2 TEAM B 06/10/2013 4 TEAM D 1 4 TEAM A 15/10/2013 5 TEAM A 1 1 TEAM E...

I need to know the function that anything =,< than 20 miles do not to do anything in Column C. And Any Miles >20 to show the result of miles >20 miles in column C. It should look like this. I have a couple hundered rows of this. <tbody> A B C Company Miles Excess Miles ABC 45 25...

Hi! So I have been pulling my hair our trying to figure out how to build a VBA for a process that is so time consuming and repetitive and deadly. background: I have hundreds of records of customer info and I am trying to categorize the job titles so that I can conduct some analysis with a...

Good morning all, I've tried to do a drop down list with special requirements. These requirements are: I choose a maker, this directs me to specific models done by the vendor. Then I choose a model and for those models, there are different sizes and specific features for each Then I came with...

Badly needed your help here masters! You will notice the "remarks" field (cell E, H, K, N, Q, T, W, Z) with a total count of 8. I have three conditions for the "final remark" (cell AC) and these are: 1. if FAILED remark counted less than equal to "7" (seven) but not "0" (zero), FINAL REMARK...