Populate one cell with x if another cell contains data/

[RodneyW]

I need a formula for cell Q8 that looks at cell E8. If E8 ispopulated, place an x in cell Q8. If itmakes a difference, cell E8 has a formula that reads from another tab withinthe same spreadsheet. Thanks in advance

 

[Joe4]

Try:

=IF(E8<>"","x","")

 

[Fluff]

How about
=IF(E8<>"","X","")

 

[RodneyW]

Fluff, same issue as with Joe. Thanks for helping find a solution

 

[Joe4]

Fluff, same issue as with Joe

Is there some issue still? I don't see anything posted to that effect.

If it is not working out, it probably means that the formula you have in cell E8 is actually returning something (like a blank space).
What exactly is the formula in cell E8?

 

[Rick Rothstein]

Here is another formula that would also work...

=LEFT("X",LEN(E8))

 

[RodneyW]

Formula in cell E8 is this: =Stations!I49
The formula in Stations I49 is: =SUMIF(G8:G46,"x",E8:E46)

 

[RodneyW]

Rick, same issue as with the other option

 

[Fluff]

As you haven't said what the issue is, this is a guess
=IF(E8>0,"X","")

 

[Joe4]

A SUMIF function would return a number, not a blank or empty string.
Perhaps you have a Custom Format hiding the zeroes.

Try:

=IF(E8>0,"x","")

Otherwise, please give us an example of one that isn't working.
(Tell us the value in I49 and what this formula is returning, and what you are expecting).