euclid1179
New Member
- Joined
- Sep 22, 2004
- Messages
- 14
I'm sure this is an easy fix but I just don't know how to go about doing it.
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?
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?