Excel question:

Can you create a number format / formula to convert a number greater than zero to a negative number, i.e. a field with value 9 becomes -9, but at the same time another field in the list with value -9 stay as -9?

Thanking you...

Posted By: Yellalee on August 4th 2008 at 15:49:52

Message Thread

Excel question: (General Chat) - Yellalee, Aug 4, 15:49:52
- multiply it by -1 (n/m) (General Chat) - blindasabat, Aug 4, 15:51:37
  - d'oh. Of course. Cheers. (n/m) (General Chat) - Yellalee, Aug 4, 15:53:07
    - actually reading your post again... (General Chat) - blindasabat, Aug 4, 15:56:32
- =IF(A1<0,A1,0-A1) (General Chat) - Arizona Bay, Aug 4, 15:51:18
  - d'oh. Of course. Cheers. (n/m) (General Chat) - Yellalee, Aug 4, 15:53:00
    - Prannying about. (General Chat) - Johnny Comecardiff, Aug 4, 17:18:13
      - =0-ABS(value) (General Chat) - Arizona Bay, Aug 4, 17:23:05
        
        Smartbum. (n/m) (General Chat) - Johnny Comecardiff, Aug 4, 17:27:12
    - Y'welcome. (n/m) (General Chat) - Arizona Bay, Aug 4, 16:23:22

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.