if(and

Hi guys, I have a column of randomly generated times using: =TEXT(RAND()*(23-10)/24+11/24,"HH:MM"). In the next column, using this formula, =IF(AND(F4>=1200,F4<=1800), "Daylight","Nighttime") I want to see if the random time falls between a "time window" and return "Daylight" or "Nighttime." I...

I'm looking to build a formula with a series of nested IF(AND statements where one of the two conditions in each IF statement looks for a certain portion of a text in a cell. For example if A1 contains "44 White Birds", and A2 contains "Willow Tree" I need cell A10 to look for "44W" in A1, and...

I have a program that I am require to use that outputs data horribly and makes it very hard to see the big picture for where everyone is for their certifications. I output everything into a CSV (only way I can) (Qualifications). I am trying to get the data to look more presentable so I can see...

Hello! This pertains to a model I am using to calculate interest rates for mortgages. Rates can be floating or fixed and the interest rate calculation method can either be Actual/360 or 30/360. There are 2x cells with dropdown choice similar to the below. (E3 & E4) which have values, and...

I have a table of employees,wages, Status and start month that looks similar to below: <tbody> Employee Position Wage Full/Part Time Hours Start Month End Month Title Example, One Maintenance 15.00 Part Time 26 5 8 Maintenance Technician Example, Two Office 15.42 Full Time 40 1 12...

Hi Can anyone help me on how to use the =IF(AND(.... to check what values that are selected from the dropdown lists and then Return correct cell value? This is my formula: =IF(AND(E4="USD";G4="Free");Cash!E25; IF(AND(E4="USD";G4="Restr.");Cash!E35; IF(AND(4="NOK";G4="Free");Cash!E5...

Okay all the big brains, I have what is probably a simple formula that has been stumping me for two days now. I did not find a specifically related thread so I'm adding this one. Problem: I want a cell to give a value based on two separate cells. The first is a standard number cell. The second...

I have three columns of numbers <tbody> A1 B1 C1 1158.50 1562.50 1250.00 </tbody> I need a formula that looks at all three numbers and returns one of them based on criteria. If A1 is bigger than B1 or C1, then B1 should be returned. If C1 is bigger than A1, then C1 should be...

Hello ! I am looking for an excel formula or VBA code for the following : If value is between x and y , then "1", else if value is between y and z; then "2", else..... So far I was actually using IF(A1<=E1;1;IF(AND(A1>=E2;A1<=E3);2;IF(AND(.......... So basically, lots of if(and()) imbricated...

Hi, I have a loan on a property that expires in 7 years. I want to model the property's sale in year 7 or earlier but not after year 7. I am trying to think of a formula that looks up what year the cash flow is in and what year the holding period is and if the cash flow year matches the...

I am building an inventory management system in Google sheets that will tell our ******* what to produce every day based on the numbers of sellable items we have on shelf. Our ******* only produces certain items on certain days and thus I want to create a list that clearly shows them what to...

Hi I am looking to enhance the formula below. I Have a "Due Date" in Cell B5 & a "Completed" Date in Cell C5. The Formula is in D5. The Results will allow conditional formatting for a RAG status. RAG > 1=RED ,2=Green, 3=Amber =IF(AND(C5="",B5<=TODAY()),1,IF(C5>B5,1,IF(C5<B5,2,3))) I'd like to...