I need to know how to leave the cell blank

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 12 May 2008 20:06 GMT

=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,F23<=$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

Reply to this Message

Gary''s Student - 12 May 2008 20:19 GMT

=IF(F23="","",your_formula) to get a blank
=IF(F23="",0,your_formula) to get a zero

Signature

Gary''s Student - gsnu200785

Reply to this Message

Peter - 12 May 2008 22:19 GMT

Thanks it got me in the right direction and I figured it out!

> =IF(F23="","",your_formula) to get a blank
> =IF(F23="",0,your_formula) to get a zero

Reply to this Message

Dave Peterson - 12 May 2008 20:20 GMT

=if(f23="",0,yourlongformulahere)

=IF(F2="",0,
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,F23<=$BT$10),$BZ$10,
IF(AND(F23>=$BS$11),$BZ$13,0)))))))

(I removed the double quotes around the 0, too.

> =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,F23<=$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

Signature

Dave Peterson

Reply to this Message

Peter - 12 May 2008 22:19 GMT

Thanks it got me in the right direction and I figured it out!

> =if(f23="",0,yourlongformulahere)
>
[quoted text clipped - 11 lines]
> > This is my formula, how do I make the cell read zero if there is no
> > information in f23

Reply to this Message

Bob Phillips - 12 May 2008 20:23 GMT

=IF(F23="","",IF(F23<=$BT$6,$BZ$6,INDEX(BZ7:BZ11,MATCH(1,(F23>=BS7:BS11)*(F23<=BT7:BT11),0))))

which is an array formula, so enter with Ctrl-Shift-Enter.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Reply to this Message

Peter - 12 May 2008 22:19 GMT

Thanks it got me in the right direction and I figured it out!

> =IF(F23="","",IF(F23<=$BT$6,$BZ$6,INDEX(BZ7:BZ11,MATCH(1,(F23>=BS7:BS11)*(F23<=BT7:BT11),0))))
>
[quoted text clipped - 3 lines]
> > This is my formula, how do I make the cell read zero if there is no
> > information in f23

Reply to this Message