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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter a formula in a cell based on value in another cell
I'm not sure what you mean? But if you just want the cell to remain
blank without displaying "Pass or Fail" when cell B9 is empty, you can write your formula this way: =IF(B9="","",IF(AND(B9<max1, B9min1),"Pass","Fail")) I hope it helps. |
Reply |
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) |