Hiding FALSE message
 

This is the formula I'm using in the cell:
=IF(G2*1.33<D2,D2,IF(G2*1.33D2,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.

Hiding FALSE message
 

On Jan 9, 12:32*pm, wrote:
This is the formula I'm using in the cell:
=IF(G2*1.33<D2,D2,IF(G2*1.33D2,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.33D2,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))

Hiding FALSE message
 

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

Tyro

wrote in message
...
This is the formula I'm using in the cell:
=IF(G2*1.33<D2,D2,IF(G2*1.33D2,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.

Hiding FALSE message
 

On Jan 9, 3:38*pm, joeu2004 wrote:
On Jan 9, 12:32*pm, wrote:

This is the formula I'm using in the cell:
=IF(G2*1.33<D2,D2,IF(G2*1.33D2,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.33D2,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!!!!

Hiding FALSE message
 

On Jan 9, 12:38 pm, joeu2004 wrote:
On Jan 9, 12:32 pm, wrote:
This is the formula I'm using in the cell:
=IF(G2*1.33<D2,D2,IF(G2*1.33D2,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.33D2,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.