SOLVED

DATA VALIDATION?

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3145917%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EDATA%20VALIDATION%3F%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3145917%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20have%20many%20different%20cells%20that%20formulate%20simple%20equations%20on%20my%20spread%20sheet.%20I%20would%20like%20for%20three%20of%20them%20to%20not%20formulate%20without%20another%20cell%20being%20marked%20X%20or%20x.%26nbsp%3B%20How%20would%20I%20do%20this%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3145917%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

I have many different cells that formulate simple equations on my spread sheet. I would like for three of them to not formulate without another cell being marked X or x.  How would I do this?

2 Replies
best response confirmed by ChrisMiller1980 (Occasional Contributor)
Solution

@ChrisMiller1980 

Let's say you now have

 

=formula

 

and that you want the cell with this formula to look blank if C2 does not contain "x" or "X". Change the formula to

 

=IF(UPPER(C2)="X", formula, "")

THANK YOU FOR YOUR HELP.