I have a workbook that has more than 1 worksheet. I need to copy figures
from my Input ws to the Posting ws if the cell in the Input sheet is greater
than a blank. However, if the value is negative, I also need to to show it
as a negative on the Posting sheet. Following is the formula I am using,
however, a negative number is showing as a positive on the Posting sheet.
How can I correct this?

=IFBLANK(Input!E7)," ",ABS(Input!E7))

Any help would be appreciated
--
Linda

Remove the ABS function.

=IFBLANK(Input!E7),"",Input!E7)

HTH
Kostis Vezerides

On Dec 21, 9:00 pm, mathel wrote:
I have a workbook that has more than 1 worksheet. I need to copy figures
from my Input ws to the Posting ws if the cell in the Input sheet is greater
than a blank. However, if the value is negative, I also need to to show it
as a negative on the Posting sheet. Following is the formula I am using,
however, a negative number is showing as a positive on the Posting sheet.
How can I correct this?

=IFBLANK(Input!E7)," ",ABS(Input!E7))

Any help would be appreciated
--
Linda

Not only should you remove the ABS function (which of course disregards the
negative sign), but you should rewrite your formula as such:
=IF(ISBLANK(Input!E7),"",Input!E7)

I don't think there is such an Excel function as IFBLANK.

It seems to me that the analysis reflected by the following part of your
post is totally unnecessary: "I need to copy figures from my Input ws to the
Posting ws if the cell in the Input sheet is greater than a blank. However,
if the value is negative, I also need to to show it as a negative on the
Posting sheet."

Whether the value in Input!E7 is positive or negative has no bearing in
this. It might even serve your purpose just to have a simple link by doing
the following (you probably already know this):
Go to the cell in your Posting sheet where you want the link to be
Type =
Go the Input sheet and point to cell E7
Press Enter

If you do the above, whatever is in Input!E7 (whether positive or negative)
will also appear in Posting sheet where you placed the link. If Input!E7 is
blank, your Posting sheet cell will also be blank.

Perhaps you have other things in mind or other factors involved that's why
you wanted to use a different formula rather than a simple link. If so, I
apologize for oversimplifying the situation. I hope this helps.



"vezerid" wrote:

Remove the ABS function.

=IFBLANK(Input!E7),"",Input!E7)

HTH
Kostis Vezerides

On Dec 21, 9:00 pm, mathel wrote:
I have a workbook that has more than 1 worksheet. I need to copy figures
from my Input ws to the Posting ws if the cell in the Input sheet is greater
than a blank. However, if the value is negative, I also need to to show it
as a negative on the Posting sheet. Following is the formula I am using,
however, a negative number is showing as a positive on the Posting sheet.
How can I correct this?

=IFBLANK(Input!E7)," ",ABS(Input!E7))

Any help would be appreciated
--
Linda