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

 

[Rick Rothstein]

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

It looks like from your formula, cell E8 will always be displaying something (either 0 or some summation value). In your original message, you said...

"If E8 is populated, place an x in cell Q8."

Well, E8 is always populated, you our formulas will always display an "X". Did you mean you wanted our formulas to display an "X" if the summation was 0 (even if you had positive and negative values that summed to 0)? If so, my formula would modify this way...

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

 

[RodneyW]

Weird, I thought I had posted a reply that outlined what the issue was, but I don't see it. In any case, Fluff, your suggestion worked perfectly. Thank you

 

[Fluff]

Glad we could help & thanks for the feedback