| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to know how to leave the cell blank
=IF(F23<=$BT$6,$BZ$6,IF(AND(F23=$BS$7,F23<=$BT$7) ,$BZ$7,IF(AND(F23=$BS$8,F23<=$BT$8),$BZ$8,IF(AND( F23=$BS$9,F23<=$BT$9),$BZ$9,IF(AND(F23=$BS$10,F2 3<=$BT$10),$BZ$10,IF(AND(F23=$BS$11),$BZ$13,"0")) ))))
This is my formula, how do I make the cell read zero if there is no information in f23 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To leave the cell Blank | Excel Worksheet Functions | |||
| To leave a blank cell | Excel Worksheet Functions | |||
| leave a cell blank | Excel Worksheet Functions | |||
| leave cell blank | Excel Discussion (Misc queries) | |||
| leave cell blank | Excel Discussion (Misc queries) | |||
Threaded Mode
