Replies: 16
| visibility 1
|
All-In [47878]
TigerPulse: 100%
Posts: 21118
Joined: 12/22/98
|
Excel junkies - question
Jan 19, 2021, 2:38 PM
|
|
I have forgotten the name of a function because I barely use it. I have a value in cell A26, and a formula in cell c26, which is a value divided by A26. So the higher the number in A26, the lower the value in C26 is. I want the value in C26 to be exactly 80. There is some function that will determine what the value in A26 should be so that C26 = 80.
Anyone?
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
Lot o points [163012]
TigerPulse: 100%
Posts: 31933
Joined: 1/17/07
|
Goal seek***
Jan 19, 2021, 2:40 PM
|
|
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
Lot o points [163012]
TigerPulse: 100%
Posts: 31933
Joined: 1/17/07
|
In my version under Data, What If Analysis***
Jan 19, 2021, 2:41 PM
|
|
lol. misspelled that the first time.
Message was edited by: Father G®
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
All-In [47878]
TigerPulse: 100%
Posts: 21118
Joined: 12/22/98
|
BINGO!!!
Jan 19, 2021, 2:44 PM
[ in reply to Goal seek*** ] |
|
You are Da Man!
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
All-In [40941]
TigerPulse: 100%
Posts: 42957
Joined: 11/30/98
|
Dangggg that is pretty sweet
Jan 19, 2021, 7:49 PM
[ in reply to Goal seek*** ] |
|
one of my programs that I wrote many years ago has a little section that I perform that function with trial and error to get my final answer. This is a perfect answer to my little dilemma. It's never been that big of a deal because I only use it once or twice a year and it only takes a few seconds, but now I'll plug this in and it will calculate for me.
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
All-In [47878]
TigerPulse: 100%
Posts: 21118
Joined: 12/22/98
|
Yeah, it is teh awesome!***
Jan 19, 2021, 8:35 PM
|
|
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
Oculus Spirit [85339]
TigerPulse: 100%
Posts: 24920
Joined: 5/21/14
|
In cell C26, type this formula
Jan 19, 2021, 2:43 PM
|
|
8 0 ENTER.
HTH
I live in excel and I don't know what you are asking.
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
Lot o points [163012]
TigerPulse: 100%
Posts: 31933
Joined: 1/17/07
|
Weird that a lot of Excel users never use goal seek
Jan 19, 2021, 2:44 PM
|
|
used to use it a lot in my working days.
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
Oculus Spirit [81925]
TigerPulse: 100%
Posts: 47122
Joined: 3/18/07
|
I still don't understand the question, it seems like a
Jan 19, 2021, 2:46 PM
|
|
simple algebra question.
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
Oculus Spirit [85339]
TigerPulse: 100%
Posts: 24920
Joined: 5/21/14
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
Oculus Spirit [81925]
TigerPulse: 100%
Posts: 47122
Joined: 3/18/07
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
All-In [47878]
TigerPulse: 100%
Posts: 21118
Joined: 12/22/98
|
Yeah, there was a little bit of that, lol.
Jan 19, 2021, 7:23 PM
|
|
Made perfect sense to me at the time.
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
Lot o points [163012]
TigerPulse: 100%
Posts: 31933
Joined: 1/17/07
|
HTH btw
Jan 19, 2021, 7:26 PM
|
|
I used it often as I did a lot of 'scenario' worksheets and it just made it a lot easier to get to some answers.
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
All-In [47878]
TigerPulse: 100%
Posts: 21118
Joined: 12/22/98
|
Twas perfeckt!
Jan 19, 2021, 8:36 PM
|
|
Throws me off every time because it is under the data tab and not under the regular functions menu.
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
Heisman Winner [119760]
TigerPulse: 100%
Posts: 54503
Joined: 6/24/09
|
Dong Log***
Jan 19, 2021, 2:43 PM
|
|
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
Oculus Spirit [75725]
TigerPulse: 100%
Posts: 108854
Joined: 10/26/03
|
Just type 80 in C26 and move on.
Jan 19, 2021, 2:49 PM
|
|
Nobody will notice.
|
|
|
|
![](https://2cic.b-cdn.net/t/forum/b.gif) |
All-TigerNet [12270]
TigerPulse: 100%
Posts: 12594
Joined: 12/1/03
|
simple math - in C26 type =80-A26+A26***
Jan 19, 2021, 2:53 PM
|
|
|
|
|
|
Replies: 16
| visibility 1
|
|
|