Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter a formula in a cell based on value in another cell
I am automating a test summary sheet for general usage.
I have test data that I am counting pass and fails for. I have 1 worksheet for each test and each test has a different number of test points. Depending on how many test points I have, I want to enter my "IF" formula ONLY if there is test data in another cell in that row. The first row of my formula is at D9 The formula is =IF(AND(B9<max1, B9min1),"pass","Fail") I want to enter the formula in D9 only if there is data in B9. I want to be able to replicate this down for 500 rows. Thanks for your help! Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to enter data of one cell based on greatest amount of anot | Excel Discussion (Misc queries) | |||
How do I enter data in an adjacent cell based on a list selection? | Excel Worksheet Functions | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |