How can I modify this function so that If it returns a 0 due to no change in
data, it will not interrupt Conditional Formatting? I have CF set to show 2
standard dev and above, but it won't work with this formula.

=(VLOOKUP($Q842,Import!$Q:$CA,3,FALSE)/(VLOOKUP($Q842,'Old
Import'!$Q:$CA,3,FALSE)))-1
--
Thank you!

Do you mean

=IF(ISNA((VLOOKUP($Q842,Import!$Q:$CA,3,FALSE)/(VLOOKUP($Q842,'Old
Import'!$Q:$CA,3,FALSE)))),0,
VLOOKUP($Q842,Import!$Q:$CA,3,FALSE)/(VLOOKUP($Q842,'Old
Import'!$Q:$CA,3,FALSE))-1)


---
HTH

Bob Phillips

"Doug" wrote in message
...
How can I modify this function so that If it returns a 0 due to no change
in
data, it will not interrupt Conditional Formatting? I have CF set to show
2
standard dev and above, but it won't work with this formula.

=(VLOOKUP($Q842,Import!$Q:$CA,3,FALSE)/(VLOOKUP($Q842,'Old
Import'!$Q:$CA,3,FALSE)))-1
--
Thank you!

I just tried this and it returns zeros all through the column. Can you see
what I did wrong?

=IF(ISNA((VLOOKUP($S3,Import!$P:$CA,4,FALSE)/(VLOOKUP($S3,'Old
Import'!$P:$CA,4,FALSE)))),0,
VLOOKUP($S3,Import!$P:$CA,4,FALSE)/(VLOOKUP($S3,'Old
Import'!$P:$CA,4,FALSE))-1)
--
Thank you!


"Bob Phillips" wrote:

Do you mean

=IF(ISNA((VLOOKUP($Q842,Import!$Q:$CA,3,FALSE)/(VLOOKUP($Q842,'Old
Import'!$Q:$CA,3,FALSE)))),0,
VLOOKUP($Q842,Import!$Q:$CA,3,FALSE)/(VLOOKUP($Q842,'Old
Import'!$Q:$CA,3,FALSE))-1)


---
HTH

Bob Phillips

"Doug" wrote in message
...
How can I modify this function so that If it returns a 0 due to no change
in
data, it will not interrupt Conditional Formatting? I have CF set to show
2
standard dev and above, but it won't work with this formula.

=(VLOOKUP($Q842,Import!$Q:$CA,3,FALSE)/(VLOOKUP($Q842,'Old
Import'!$Q:$CA,3,FALSE)))-1
--
Thank you!


.