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 ...
Hi Ghada,
You formula first checks if AA1 is equal to BB1 and returns TRUE or FALSE (1 or 0) and after that compare with "ok". That is always FALSE, thus the result is always "check"
=IF(AND(AA1="ok",BB1="ok"),"ok","check")
Many thanks. It worked :)
