If - Then formatting
Posted by Monica on August 20, 2001 2:21 PM
How do I get Excel to return a value in one cell based on what is input in another cell. Example, if I put "yes" in A1, I want Excel to put "Approved" in B1.
Posted by gregc on August 20, 2001 2:29 PM
in B1 put =if(A1 = "yes","Approved,"")
