if(formula)
Thanks it worked.
"Pete_UK" wrote:
Try it like this:
=IF(ISNA(MATCH(A1,[B23177Takeoff.xls]H23177!$A$1:$A$3,0)),4,14)
This implies that the takeoff file is open at the same time. I've also
removed the " from around the numbers as that will change them to text
values.
Hope this helps.
Pete
On Sep 27, 12:24 am, MicheleP
wrote:
Hi,
I've tried creating a formula that will return the value "14" if true or "4"
if false but i can't get in to work.
*=IF([B23177Takeoff.xls]H23177!$A$1:$A$3=A1,"14","4"). I'm compare two
separate spread sheets and the formula is in Book1 C1, C2, etc. When in
enter C1 the it returns the correct infromation, but once I enter in C2 it's
incorrect.
Book1 B23177Takeoff
A B C A B C
1 200 14 1 200
2 201 4 2 202
3 203 4 3 205
Any help would be much appreciated. MicheleP
|