Results 1 to 12 of 12

multiply specific number only on positive #

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-30-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    234

    multiply specific number only on positive #

    A1=7
    A2=2
    A3= -8
    A4= -10
    A5= 12
    A6= 56
    A7= -100

    B1=7*0.05
    B2=2*0.05
    B3= -8
    B4= -10
    B5=12*0.05
    B6= 56*0.05
    B7= -100

    hello everyone is there a formula to make positive number multiply by 0.05 ,and negative number remain the same?

    thank you
    Last edited by Exxcel Noob; 06-17-2012 at 02:54 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1