Excel Question

[JeffITman]

I am pulling data from another worksheet in the same workbook.

This is what i'm using:

=!sheet2!n26-1

The problem is that there is data in n25 and that copys fine but there is currently no data in n26 and it returns "value" on sheet1. There will be data there in the future. Is there any way to keep that blank but keep the formula for a future time.

I tried:

=!sheet2!n26-1,

 

[Lilliabeth]

1. As written, your formula shouldn't be returning anything at all - it has an extra ! symbol

2. Take out the extra ! and your formula should return -1

If you were havng a problem with a formula b/c a cell was blank, you could do something like this:

=IF(ISBLANK(Sheet2!N26),"",Sheet2!N26-1)

Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[JeffITman]

That's still giving me the "value" problem.

 

[Lilliabeth]

Sheet2!N26 is not blank then.

Select it and press the delete key

Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[xlbo]

=IF(Sheet2!N26="","",Sheet2!N26-1)

Could be the result of another formula setting itself to "" instead of blank

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question