Summary: I have 3 entries generated by if statements in 3 cells next to each other. D1, E1, F1. Based on the IF statement outcomes, only one of these cells wil...
Summary: Hi, I was wondering if someone could help me get an Excel IF statement right. I am making a test, and I need to convert the raw score into a standard ...
Summary: hi im doign some work for my IT class and im stuck on a formula basiclaly im trying to do an if statement with the IF TRUE calculating another fomula...
Summary: I have a worksheet with a summary page and a detail page. The IF statement is in one cell on the Summary page =IF(Detail!H6="Voided",-Detail!D6,0)and ...
Summary: What is the formula for an IF statement to hilight any value or text, if that value appears more than one time in any given column? Using conditional...
Summary: I'm am setting up a spreadsheet to track fuel consumption and hour of heavy equipment. I have conditional formatting set to change the color of a cell...
Summary: I need help adding a range of cells. Each cell in the range was determined by the if statement: =IF(K12>40,K12-40,L12=0. When I add the range L5:L16 I...
Summary: If you really only have three columns of data, then you can do it with a single brute force nested IF statement. The problem is that any more than 3 c...
Summary: Could I please obtain some help creating an Excel IF statement, considering the following parameters: - There is a date in cell A1 - The statement wil...
Summary: I am trying to create a formula (if statement) that will do the following and need help? I am adding up three cells (G21+G21+G23)and dispayng the sum ...
Summary: I need some help creating an IF statement in Excel. If there is text in (G19) then I would like it so that (T19) produces a result if (S19) meets the ...
Summary: Yeah, what you need is conditional formatting. With it you can highlight cells and color them, depending on their values. The if statement won't forma...
Summary: Hi i neeed some help im trying to do an if statement in excel but i need to make if so it recognises it in every cell in column BO and BP without hav...
Summary: HELP PLEASE. I need to write an IF statement to to determine the discount given if a client pays his fees in advance. The raw data is: <7 day no di...
Summary: Is there a way to write an if statement that will make a cell turn a specific color? For example, if the word yes appears in cell b3, b2 turns red. ...
Summary: Dear all, Please help me to create nested if statements for below case: in the colomn G there are 3 digit number: 110 (candy), 111 (cake), 112 (lollie...
Summary: I need a "if" statement that will allow me to pull back pass or check for multiple cells. For example: if J3 = pass than pull back "pass" in cell a3...
Summary: I have a set of dates in the format dd-mmm-yy in column a and have 2 conditions of jobs 1, 2 & 3 in column b. I would like column c to: - return the d...
Summary: I am trying to make an if statement that accomplishes something like, If b1=3 then a2=a1 else pick choice from the data validation list(drop down list...
Summary: I want to see if I can create an IF Statement where if the value ends up with a "divide by zero error #DIV/0! " then it returns a result of zero. ...
Summary: You know what, I think I got it to work using your formula and I added IF(BP2<=.99,.09) to the rest of the formula. I didn't know that adding anoth...
Summary: Hi, I have a question regarding if-statements in VBA. I have a time-series of interest rates (A2) and calculated the daily percentage changes (B2). N...
Summary: I have a column that has both blank cells and cells populated with amounts, there are no formulas in any of the cells. I want to change the blank cel...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
