nested if and

Hello I would appreciate some help with a spreadsheet I have. I am trying to determine the responses from a survey that is sent out weekly. The respondent reply options are Yes or No, but I would also like to record if they dont respond. I have Sheet 1 where the survey results are pasted...

Hi all, I have been really struggling with this question I was wondering if anybody could help. 1). A student receives a UCPD award if they have completed 3 modules successfully and a UCAPD if they have completed 6 modules successfully. In column N enter a nested IF formula which determines...

How do I write this in a formula If Cell E33 is equal or greater than 0 and if A33 is blank then leave active cell Z33 empty. but If Cell E33 is not equal to but greater than 0 and if A33 is not blank then return E33's value to Z33 =IF(and(E33>=0,A33="","") =IF(and(E33>0,A33<>"",E33,"") I...

Hi guys, i'm under pressure to get this done in next 3 hours ao any help would be appreciated. lets say I have 4 cells ABCD. The text in A can will either say "Pass" or "Fail" depending on the following: IF (B,C,D = blank ) then A=“Pass” If B not blank but C,D are Blank, then A=“Fail” If B is...

Good day Excel forum, I need the help of an expert to solve a puzzling and challenging problem. I will try to explain in the shortest way possible, but need to be thorough to explain in clarity. In the table below, I have need of a formula in the "Code" column to do some very specific...

Hello, I've searched and tried for about an hour. I'm sure it's easy, but I can't see it! Can anyone help me fix the following...

Hi All, Currently i have an issue where i want to have 15 if(and functions that have 4 conditions in each but it says im not allowed have that many in a nested if statement. An example of the current formula i am using is: =IF(AND(H2="Y",I2="Y",J2="Y",K2="Y"),"All are...

Can someone help me please. I want to know how I can make an if then statement for employee pay. I have seven different levels of pay. B, C, D, etc. Under each level of pay are different rates. If level B compensated employees make less than 75 units then they should be paid $8 per unit. But...

Hi guys! Marcelo Branco gave an excellent answer to another user on here at this thread of which I am using the formula. However, I need to take it one step further: I need to nest two IF statements to my current formula...

Excel 2007 Windows 8.1 Hello everyone, and thank you in advance!!! I am creating a commission worksheet for my real estate agents so they can easily track their earnings for every deal. I have essentially found the solution (thanks to the second-half of a YouTube post from MrExcel), but do...

PLEASE HELP! I've entered this nested formula and Excel is not accepting it. For the life of me I can't see what I've left out or put in that's not working. I haven't used nested formulas for awhile so I'm rusty and hoping this is something simple I've over looked. Thanks in advance for your...

I've found multiple threads answering the question about using multiple logical tests with an if function with Excel 2010, and the consensus approach is: =IF(AND(Test1,Test2),ValueTrue,ValueFalse) However, when I try to use this in an array formula I end up with a #VALUE! error. I am trying...

<colgroup><col style="mso-width-source:userset;mso-width-alt:4022; width:83pt" span="2" width="110"> </colgroup><tbody> F Original Score G Rating 26 4 18 6 </tbody> I have created a nested IF statement to average out the...

Hi! First of all: I'm very new to excel so please be patient and just ask if you don't understand the question. The problem. I have a large excel table (around 10 000 rows) and I would like to create a graph that shows how many of certain products are in a certain price range. So for example...