I need a formula that If One Cell Equals Certain Text, Then Another Cell Equals The Value Of Another Cell...
at the mo i've got
=IF(A2="PAID OUT", "OK", "Not OK")
but instead of the cell reading OK or Not OK, i need it to equal another cell. ie, if A2="PAID OUT", then =B2
how do i do that?