I have two cells and wish to dislpay diferent text in onem dependant upon the text in the other. Cell A1 usually has “result” dosplayed and cell A2 “lost/WON. If “WON” is typed into cell A1, I wish A2 to display “WON”. If anything else is typed into cell A1, I wish cell A2 to display “lost”. The following formula does not appear to be accepted: =IF(A1=”result”,”lost/WON”,if(A1=”WON”,”WON”,”lost”)).
By: John Banwell