Hiding FALSE message

[djohns158]

This is the formula I'm using in the cell:
=IF(G2*1.33<D2,D2,IF(G2*1.33>D2,G2*1.33))
Now.... if there is no data in that particular row, then the word
FALSE is in that cell. Is there some way to make it so the cell is
blank until I enter data? I'm almost done with this project and
you've all been so helpful. Thank you.

 

[joeu2004]

This is the formula I'm using in the cell:
=IF(G2*1.33<D2,D2,IF(G2*1.33>D2,G2*1.33))
Now.... if there is no data in that particular row, then the word
FALSE is in that cell.  Is there some way to make it so the cell is
blank until I enter data?

You are missing the 3rd argument of the 2nd IF() function call.
Change to:

=IF(G2*1.33<D2,D2,IF(G2*1.33>D2,G2*1.33,""))

Are you sure you truly want a blank in that case. I would think you
want:

=max(D2, G2*1.33)

Alternatively, to give you exactly what you wrote:

=if(G2*1.33=D2, "", max(D2,G2*1.33))

 

[Tyro]

=IF(G2*1.33<D2,D2,IF(G2*1.33>D2,G2*1.33,""))

Tyro

 

[djohns158]

You are missing the 3rd argument of the 2nd IF() function call.
Change to:

=IF(G2*1.33<D2,D2,IF(G2*1.33>D2,G2*1.33,""))

Are you sure you truly want a blank in that case.  I would think you
want:

=max(D2, G2*1.33)

Alternatively, to give you exactly what you wrote:

=if(G2*1.33=D2, "", max(D2,G2*1.33))

It worked... thank you so much... You guys are awesome!!!!

 

[joeu2004]

This is the formula I'm using in the cell:
=IF(G2*1.33<D2,D2,IF(G2*1.33>D2,G2*1.33))
Now.... if there is no data in that particular row, then the word
FALSE is in that cell. Is there some way to make it so the cell
is blank until I enter data?

[....]
=IF(G2*1.33<D2,D2,IF(G2*1.33>D2,G2*1.33,""))
[....or....]
=max(D2, G2*1.33)
[....]
=if(G2*1.33=D2, "", max(D2,G2*1.33))

You seem happy with one or more of the alternatives that I provided.
But they were based on your original formula. When I reread what you
truly wanted -- what a concept! -- namely blank when "there is no data
in that particular row", I realized that you might have written the
wrong formula in the first place.

I suspect you truly want one of the following, depending on your
requirements:

=if(and(G2="",D2=""), "", max(D2, G2*1.33))

=if(or(G2="",D2=""), "", max(D2, G2*1.33))

The second formula requires data in both cells. The first formula
requires data in only one cell, treating the remaining blank cell as
zero..

That is, I suspect you actually do want zero, not blank, when D2 and
G2 are both zero (as well as when D2 = G2*1.33). I suspect you merely
stumbled onto the fact that when D2 and G2 are blank, D2=G2 is true
because both are treated as zero, and you want blank in that case.