Formula that looks at value in a cell and depending on what the value is
Solution 1:
You'll need nested if()
statements, like:
if 25 then Account1 otherwise (else), if 58 then Account2 otherwise...
=IF(A1=25,"account1",IF(A1=58,"account2",""))
The format for the IF()
function is IF(logical_test, value_if_true, [value_if_false])
and you're just placing another IF()
function in the [value_if_false]
repeatedly.