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 topick 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.42KViews0likes4Comments