Cell recognize once data in another cell

[TMILJVIPM]

I asked a similar question earlier but this cell has a different formula so the same formula from my earlier post isnt working for me. Here's what I have:

I only want cell Y15 to populate once cell X15 shows data. Now Y15 already has this formula in it =average(x15/u15*100)

Thanks in advance

 

[jeffreybrown]

Try this...

=IF(N(X15),X15/U15*100,"")

 

[T. Valko]

I asked a similar question earlier but this cell has a different formula so the same formula from my earlier post isnt working for me. Here's what I have:

I only want cell Y15 to populate once cell X15 shows data. Now Y15 already has this formula in it =average(x15/u15*100)

Thanks in advance

If 0 is a valid entry for cell X15...

=IF(COUNT(X15),X15/U15*100,"")

 

[TMILJVIPM]

Yes sir. Thank you!