'If cell contains ["text"], return ["text2"], else...leave it alone
I am using a shared spreadsheet from my company's Sharepoint site, so it's the "online" version of Excel. Basically, If text in column G equals "Classical", I need column I to return text "SC". For anything else, I need it to remain as is (there is already data in column I). Right now, the formula below is returning "SC" for all. I am entering this formula in column I, so I'm assuming this is some kind of circular reference issue. Is there a workaround?
=IF(G17="Classical","SC",I17)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|