[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

Excel Formula

I need a formula that looks at a value in a cell A1 and has to decipher the following:

If the value is negative such as (-125) you divide 100 by 125 -> 100/125 = 0.8
If the value is positive such as  (+130) you divide 130 by 100 -> 130/100 = 1.3

The value in cell A1 changes from positive to negative often.
0
elwayisgod
Asked:
elwayisgod
  • 4
1 Solution
 
FlysterCommented:
=IF(A1<0,100/A1,A1/100)

Flyster
0
 
elwayisgodAuthor Commented:
Every result must be a positive number.  The above gives me -0.8 for a -125 value when it should be 0.8
0
 
elwayisgodAuthor Commented:
Works for the +130 value though
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Chris BottomleyCommented:
Just a tweak:

=IF(A1<0,100/-A1,A1/100)

Chris
0
 
elwayisgodAuthor Commented:
I got it.. put in a * -1 in first part.....
0
 
elwayisgodAuthor Commented:
Posting another one related as now I have to evaluate something..
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now