#### euclid1179

##### New Member

- Joined
- Sep 22, 2004

- Messages
- 14

Here are columns I have:

New effective Price (K)

Presumed New Blend Price (S) - this works off of formulas in a separate book

Blended Price (X)

So, in column X I am taking the number from column S (which is calculated and not a "hard" number) and am adding .02 via the following formula: =+S6+$S$2 (the $S$2 holds the .02 number)

In the next column (Y) I am using the IF function to determine if column X=K.

I'm running into problem using this statement because it seems that excel is recognizing the formula only in column X and not the resulting number. So while Column X truly equals Column K, excel is telling me they do not equal because in column K it sees ".50" and in column X it sees "=+S6+$S$2"

Anyone know how to make column X look like a single number to excel?