| Home |
| Search |
| Today's Posts |
|
#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. |
| 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) | |||
![Moose[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
