Excel formula to make input number its inverse?

Question

I want to be able to input a number in a cell and automatically have it convert to its inverse (in that same cell). Is there a forumla for that?

Answer 1

No formula can do this.
Formulas are have to be entered in a cell first to work.
So You will need a VBA to do this
put this VBA macro in the code area of any sheet you want to do this:

Private Sub Worksheet_Change(ByVal Target As Range)
ActiveCell.Value = 0 - Val(ActiveCell.Value)
End Sub

need more info? mail me here in Y! Answers

Enjoy my profile, I am the VBAXLMan

Answer 2

Excel has a fundamental principle about cells. They can either contain a value or a formula but not both. To accomplish what you're asking would require a macro to take the input value, calculate inverse and then insert the result into same cell.

You would be better off having the cell with input value separate from the formula for inverse value. But that brings up the more important problem. You cannot simply calculate an inverse of a single numeric value. It must be compared to something else to caluclate inverse.

For example:

A = 123
B = 0
C = -123

Therefore, C is the inverse of A proportionally to B.

Hope this helps.
Kind Regards,
QwertyKPH @ Yahoo

Answer 3

1

Answer 4

Inverse Function Excel

Answer 5

This Site Might Help You.

RE:
Excel formula to make input number its inverse?
I want to be able to input a number in a cell and automatically have it convert to its inverse (in that same cell). Is there a forumla for that?

Answer 6

Not precisely sure what you want by inverse, but type INVERSE in the Excell help bar and it will give you several functions. As for making it happen in the same cell I'm not sure it's possible. But making it happen in an adjoining cell should be easy enough

Good luck

Answer 7

For the best answers, search on this site https://shorturl.im/axGwU

If you want the count, use COUNTIF. Formula is =COUNTIF("choose the cells you want to count", "criteria when the cell should be counted or not") If you'd like the sum and there's only 1 criteria, you may use SUMIF. Formula is =SUMIF("choose the cells you want evaluated", "criteria", "choose the cells you want totaled"). If there's multiple criteria, you may consider using SUMPRODUCT. You may also just create a pivot table (Data >> Pivot Table and PivotChart Report).

Answer 8

open your spread sheet position your cursor in the box you want the count in go to insert function a dialog box will appear click count and then another dialog box appears and asks for your cell range enter the cell range and there you have it