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: How would I construct a statement in Excel to look in three cells e.g.(A1,A2,A3), for a value greater than 7 and add 1 to cell (A4) for each value fou...
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: basically, I want to put a figure in cell A1, in cell B1 i will have a yes or no. If in B1 it says Yes I want it to carry the figure over thats in A1 ...
Summary: I am trying to create an excel spreadsheet that will calculate hours added and hours lost in a work day. I am a scheduler and I need to track how many...
Summary: I would like to write an if statement for the following. I have two columns of names. One column has 169 names and the other has 409. I need to ma...
Summary: I have been trying to use an IF statement to compare date/time entries in a report I am building (format = yyyy-mm-dd hh:mm:ss). Essentially there are...
Summary: You'd need to do a nested IF. IF statements are If this this true, then do this, ELSE do this. A Nested IF is the way to go. Life is more painless fo...
Summary: I have 5 colums A - E. a1 = 30 b1 = 20 c1 = 25. Column D has an IF statement saying =IF(C1<A1,1,0) I want to add a statement to E that says IF(C1...
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: I have a date in cell (f7) and want to add 30 days onto it in cell (i7) but, if the date in cell (i7) turns out to be greater than Oct 15 I want to su...
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 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: I know how to use an IF statement to change the value of a cell in MS Excel (Office XP). But can the color of the text be changed also? Or the backgro...
Summary: Hi all - first time poster here - been having at a multiple If AND statement in Excel that I just can't get right. There are four variables and I'm t...
Summary: re: This approach eliminates nested if statements, they are confusing to debug... Just an FYI for those that aren't aware of these 2 debugging tools: ...
Summary: Hi, If it was an assignment, then it is for you to work out the solution and not get someone else to do it for you. If you can't work out the solution...
Summary: Hi there. I'm hoping someone can help me simplify a function that I'm using in excel. Basically I have rows of data, e.g. Row 1 - XOOXO Row 2 - XXXXO ...
Summary: I have an excel programming problem I can't seem to get. I have a spreadsheet with the following cell formula that works fine: =IF(C20="","No Quote",...
Summary: Thank you in advance for any help. I'm using several excel sheets as a database/Log. We may be able to kill a few birds with one stone...let's try. I...
Summary: Fred, I asked because I know you can save a file in Excel 97 as a database file (DBF2,3 or 4) but have never used it. I don't know how it would be use...
Summary: I have a spreadsheet that has a lot of formulas and validations in it. The formulas are simple =if(or(....)) statements. I would say there would nee...
Summary: I'm a new poster (long time reader). I'm hoping someone can help me with a problem I've encountered. I'm working w/ a pretty elaborate excel spreads...
![[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
