=IF(A2="PAID OUT", B2, "Not OK")
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?
There are currently 10 users browsing this thread. (0 members and 10 guests)