ExcelBanter - use value not formula in IF statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - use value not formula in IF statement (https://www.excelbanter.com/excel-worksheet-functions/142356-use-value-not-formula-if-statement.html)

Soz

use value not formula in IF statement

I'm using a basic IF formula =IF(j2=i2,"yes","no") but i2 has a Vlookup
formula. Can I use the If statement above to use the value of the formula and
not the formula?

Peo Sjoblom

use value not formula in IF statement

If you refer to a cell with a formula in another formula it will use the
value and not the text string of the formula

--
Regards,

Peo Sjoblom

"Soz" wrote in message
...
I'm using a basic IF formula =IF(j2=i2,"yes","no") but i2 has a Vlookup
formula. Can I use the If statement above to use the value of the formula
and
not the formula?

CLR

use value not formula in IF statement

The formula naturally works on the resultant value of the formula, not the
formula itself.

Vaya con Dios,
Chuck, CABGx3

"Soz" wrote:

I'm using a basic IF formula =IF(j2=i2,"yes","no") but i2 has a Vlookup
formula. Can I use the If statement above to use the value of the formula and
not the formula?

All times are GMT +1. The time now is 01:23 AM.