Tiger Board Logo

Donor's Den General Leaderboards TNET coins™ POTD Hall of Fame Map FAQ
GIVE AN AWARD
Use your TNET coins™ to grant this post a special award!

W
50
Big Brain
90
Love it!
100
Cheers
100
Helpful
100
Made Me Smile
100
Great Idea!
150
Mind Blown
150
Caring
200
Flammable
200
Hear ye, hear ye
200
Bravo
250
Nom Nom Nom
250
Take My Coins
500
Ooo, Shiny!
700
Treasured Post!
1000

YOUR BALANCE
Excel junkies - question
storage This topic has been archived - replies are not allowed.
Archives - General Boards Archive
add New Topic
Replies: 16
| visibility 1

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?

2024 white level memberbadge-donor-10yr.jpg flag link military_tech thumb_downthumb_up

MauldinT, where are you???


Goal seek***


Jan 19, 2021, 2:40 PM



2024 orange level memberbadge-donor-15yr.jpgringofhonor-fatherg-110.jpg flag link military_tech thumb_downthumb_up

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®


2024 orange level memberbadge-donor-15yr.jpgringofhonor-fatherg-110.jpg flag link military_tech thumb_downthumb_up

BINGO!!!


Jan 19, 2021, 2:44 PM [ in reply to Goal seek*** ]

You are Da Man!

2024 white level memberbadge-donor-10yr.jpg flag link military_tech thumb_downthumb_up

MauldinT, where are you???


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.

2024 orange level memberbadge-donor-10yr.jpg flag link military_tech thumb_downthumb_up


Yeah, it is teh awesome!***


Jan 19, 2021, 8:35 PM



2024 white level memberbadge-donor-10yr.jpg flag link military_tech thumb_downthumb_up

MauldinT, where are you???


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.

flag link military_tech thumb_downthumb_up


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.

2024 orange level memberbadge-donor-15yr.jpgringofhonor-fatherg-110.jpg flag link military_tech thumb_downthumb_up

I still don't understand the question, it seems like a


Jan 19, 2021, 2:46 PM

simple algebra question.

2024 orange level memberbadge-donor-10yr.jpg2011_pickem_champ.jpgbadge-ringofhonor-soccerkrzy.jpg flag link military_tech thumb_downthumb_up

Cole @ Beach Cole w/ Clemson Hat


No, I've never used it...will check it out, may not apply


Jan 19, 2021, 2:46 PM [ in reply to Weird that a lot of Excel users never use goal seek ]

to my normal use, idk.

flag link military_tech thumb_downthumb_up


At least Father G could understand the aero question.***


Jan 19, 2021, 2:45 PM [ in reply to In cell C26, type this formula ]



2024 orange level memberbadge-donor-10yr.jpg2011_pickem_champ.jpgbadge-ringofhonor-soccerkrzy.jpg flag link military_tech thumb_downthumb_up

Cole @ Beach Cole w/ Clemson Hat


Yeah, there was a little bit of that, lol.


Jan 19, 2021, 7:23 PM

Made perfect sense to me at the time.

2024 white level memberbadge-donor-10yr.jpg flag link military_tech thumb_downthumb_up

MauldinT, where are you???


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.

2024 orange level memberbadge-donor-15yr.jpgringofhonor-fatherg-110.jpg flag link military_tech thumb_downthumb_up

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.

2024 white level memberbadge-donor-10yr.jpg flag link military_tech thumb_downthumb_up

MauldinT, where are you???


Dong Log***


Jan 19, 2021, 2:43 PM



flag link military_tech thumb_downthumb_up

Just type 80 in C26 and move on.


Jan 19, 2021, 2:49 PM

Nobody will notice.

badge-donor-05yr.jpgringofhonor-aero.jpg flag link military_tech thumb_downthumb_up

simple math - in C26 type =80-A26+A26***


Jan 19, 2021, 2:53 PM



flag link military_tech thumb_downthumb_up

Replies: 16
| visibility 1
Archives - General Boards Archive
add New Topic