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: 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 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: I'm using Excel 2003 and would like to know if there is any way to use an OR function along with the IF function. An example would be: IF(B2=1 OR 2,3,...
Summary: I need a bit of assistance from someone who might be an Excel whizz. I am trying to create an Excel document that will allow me to draw up rental cont...
Summary: Following is the example I use when trying to remember how to use AND or OR within an IF statement: =IF(OR(AND(A1>1,B1<10),C1=5),D1,0) i.e. IF (A1>...
Summary: I would like to know how I would put in a if statment in a excel spreadsheet. The if statment is if it is a negative figure then type in red and bold...
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: 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: There are 2 problems with the construction of your If statement. First, the syntax of an IF statement is: IF(logical_test, value_if_true, value_if_fal...
Summary: As I suspected, you do not have anything set for the value_if_false for the final IF statement. Keep in mind that Excel evaluates the Nested IF's in ...
Summary: Hello, I need help with a formula: I have two worksheets in an excel file: Worksheet1 (month): A -------- B DATE --- BUDGETED HOURS 01/09 ---- “...
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: When viewing a spreadsheet in Excel, if you have one column that has a long string of text how can you hide the text that the next column covers. I k...
Summary: These errors are always difficult to troubleshoot, but here are some "long shots." 1. Use the system file checker (available in start-programs-access...
Summary: Hi JCKS I've seen this before and I wrote the following script to try to sort it out. It DIDN'T WORK IN ALL CASES. But it did in some - so you may as ...
Summary: I have received Supercalc .cal s/sheets that I cannot open in Excel. I don't know whether these are from a dos based or windows Supercalc app. or what...
Summary: Fred, Is this database established within Excel? If so, can you provide a quick-step guide? I am interested. Bryan P.S. I am not so sure that an inval...
Summary: When working in excel if I hit enter key it's doesn't automatically scroll down to the next row. instead hitting enter keeps the item on the same fie...
Summary: Now when I startup WORD, it automatically tries to start and open a file in Excel. If Excel is already running WORD crashes. Thanks for any suggestion...
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: Ok, another questions for Excel. If you see my post about Macros in MS Office which really didn't deal with Macros I wanted to have a doc open everyt...
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...
![[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
