Forum Discussion
Ghada Saleh
Oct 23, 2017Copper Contributor
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 pick up the OK or check. If(AA1=BB1="ok","ok","check") but currently is not recognising the values.
Tried to add text to cell AA1 : =TEXT(if(B1=C1,"ok","check"),"TEXT")
Still the values are not recognised.
- Sotannde Abiodun KabirCopper ContributorYou only ran into a syntax error. The formula is simply:
=If(BB1=CC1,"OK","Check")
Instead of
=If(BB1=CC1="OK","Check")- Ghada SalehCopper ContributorThanks :)
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")
- Ghada SalehCopper Contributor
Many thanks. It worked :)