Exclude formulas in when referencing a cell

[searnold56]

Hello All,

This one makes me feel dumb...

If I am using the formula =IF(A1>1,X,""), how do I exclude the X from appearing if there is only a formula in the cell? I only need it to pull an X if a value is in the cell.

Thank you!

[oeldere]

Post your excel file, without confidentional information.

Please also add the desired result.

[searnold56]

Book1.xlsDifficult to remove the sensitive info. Attached is the basic setup

[oeldere]

I don't see formula's in your sheet 2 (as you told us in your question #1)

Please Login or Register  to view this content.

[BMEProgrammer]

I'm not sure if this is what you're looking for, but:

In Cell A1: =IF(AND(B1>1, NOT(B1="")),"X", "")

The above formula will input an X if there is a value greater than 1 in B1 and will input nothing if there is nothing showing in B1, even it if contains a formula. I get what I think is your desired result in your example sheet, but I don't know if it applies to your greater problem.

[searnold56]

That works! Thank you!