Posted to microsoft.public.excel.worksheet.functions

CLR

external usenet poster

Posts: 1,998

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF THEN statement - Formula	walkerT	Excel Discussion (Misc queries)	3	March 13th 07 07:20 PM
IF statement formula	JaB	Excel Worksheet Functions	4	September 15th 06 04:12 PM
Can I use IF statement with a formula?	Michael NYC	Excel Worksheet Functions	1	October 1st 05 04:45 AM
if statement formula	Marlis	Excel Discussion (Misc queries)	2	August 17th 05 04:57 AM
If statement formula	lintan	Excel Worksheet Functions	6	November 22nd 04 10:29 PM

All times are GMT +1. The time now is 05:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us