A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Copy a Negative value to another WS



 
 
Thread Tools Display Modes
  #1  
Old December 21st, 2007, 08:00 PM posted to microsoft.public.excel.worksheet.functions
mathel
external usenet poster
 
Posts: 5
Default Copy a Negative value to another WS

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
  #2  
Old December 21st, 2007, 08:17 PM posted to microsoft.public.excel.worksheet.functions
vezerid
external usenet poster
 
Posts: 739
Default Copy a Negative value to another WS

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


  #3  
Old December 21st, 2007, 10:16 PM posted to microsoft.public.excel.worksheet.functions
Trying
external usenet poster
 
Posts: 49
Default Copy a Negative value to another WS

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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.