Forum Discussion
Formula to read value rather than the formula in the cell
Trying to form a formula that picks up data from other cells. The values in the other cells are from formulas. eg AA1: formula =if(B1=C1,"ok","check"), My formula in another cell is supposed to ...
You only ran into a syntax error. The formula is simply:
=If(BB1=CC1,"OK","Check")
Instead of
=If(BB1=CC1="OK","Check")
=If(BB1=CC1,"OK","Check")
Instead of
=If(BB1=CC1="OK","Check")
Thanks :)