What-if Analysis in Excel with a 2-input data table

[cyrusxty]

Excellent! This helps me a lot!

[DannyRocksExcels]

@cyrusxty

Thank you. I am very pleased that I could help you with this.

Danny Rocks

The Company Rocks

[Mirkocc14]

very well explained!

[DannyRocksExcels]

@Mirkocc14

Thank you for adding your comment!

Danny Rocks

The Company Rocks

[mona12393]

Hi Danny,

i also have tried some many times its gud but i just wanted to know,when i am putting the formula of PMT to calculate monthly payment its coming negative ( amount is exact) .Why don't know? can you please help me out.

[DannyRocksExcels]

@mona12393

The result of the PMT Function represents an "Outflow" in accounting terms. That is, you monthly payment comes out of (Outflows) from your checking account, etc.

If you wish to see the result as a "positive" number, do either of these:

1) Insert a - after the = sign amd before PMT (=-PMT()

2) When you refer to the cell of the 3rd argument PV, put a negative sign in front - e.g = -A3

Danny Rocks

The Company Rocks

[777azza]

You are THE MAN! This helped so much.

Cheers mate

[DannyRocksExcels]

@777azza

Thank you! I am pleased that I could help you.

Danny Rocks

The Company Rocks

[khanriza]

Your one badass teacher.

I hope your getting paid well ;D.

[DannyRocksExcels]

@khanriza

Thank you!

Re" getting paid well - "Your lips to God's ears!"

I appreciate you taking the time to write to me.

All best wishes as you improve your Excel skills.

Danny Rocks

The Company Rocks

[sddentdoc]

Danny: I just wanted to tell you how much I enjoyed your Excel tutorials. They are clear, concise, and very informative. As an instructor I appreciate how difficult it is to explain complex subjects. You have a real gift for teaching. You make everything - even complex Excel features - easy to understand. You truly do rock! Doug

[DannyRocksExcels]

@sddentdoc

Thank you for your very generous words about my teaching skills. I love to teach and I love it even more when my students get an "A-ha / now I understand it" moment.

I put a lot of work into preparing my lessons so that I can make the concept that I teach as clear and simple as possible, Thank you for recognizing this.

Danny Rocks

The Company Rocks

[navegaur]

Very helpful Danny

[DannyRocksExcels]

@navegaur

Thanks for writing. I am pleased that I could help you.

Danny Rocks

The Company Rocks

[dschoenenberger]

fantastic, very useful, just what i needed

[DannyRocksExcels]

@dschoenenberger

Thank you for writing to tell me that I helped you. I appreciate that.

Best wishes,

Danny Rocks

The Company Rocks

[ericdmann]

Thanks, very helpful!

[DannyRocksExcels]

@ericdmann

It is my pleasure. Thank you for writing to tell me.

Danny Rocks

The Company Rocks

Training You to Excel

[oneggold]

GREAT ! thanks so much, everybody showing the "seek answer" in the "what-if" finally someone showed the other option.

[DannyRocksExcels]

@oneggold

Thank you for writing. I am pleased that you enjoyed my video lesson for Excel.

I invite you to visit my website - The Company Rocks - to see all of the many resouces that I offer.

Sincerely,

Danny Rocks

[DannyRocksExcels]

@propnash

I have created a new video to show you how to fix the result of your formula. Go to my latest YouTube Video - Use Goal Seek to Find Formula Error - to see this,

I used Goal Seek to isolate the problem - you need to correct the FORMATTING for your Interest rate - in your spreadsheet, the rate was formatted to be 800% rather than 8%

Thank you for seeking my help. I am glad that I was able to find the answer for you.

Danny Rocks

The Company Rocks

[propnash]

HI DANNY ROCKS, Need help, i key in below information i am getting wrong monthly payment.my PMT formula reads =PMT(B5/12,B4,-B3)

B3:HOUSE 16000

B4:#OF PAYMENTS 36

B5:INTEREST RATE  8

B6:MONTHLY PAYMENT $10,666.67

....REGARD'S

NASH

[DannyRocksExcels]

@gunzblazin108

I am so pleased that I was able to save you hours performing this analysis.

I know what you mean - for years, I struggled to understand this concept. Most of the "explanations" that I came across left me more confused than when I started.

Thank you for your feedback,

Danny Rocks

The COmpany Rocks

[zenshinify]

you don't need to remove the mouse click sounds. they are actually quite good. you do have to bring the volume levels of your voice up in proportion to other sounds. that's why i recommended learning a bit about audio compression and mastering. there are no professional recordings which were not processed using a compressor, but it's a good practice even for DIY projects. it would help bring presence to your voice. the video is otherwise informative, and i too learned something.

[DannyRocksExcels]

@zenshinify

Thanks - I now use a highlighter that points to the cell when I click inside. This seems to work well for me and for my audience.

Sincerely,

Danny Rocks

The Company Rocks

[gibsonsimpson]

Thanks. I could not figure out how to do this with Excel's "help".

[DannyRocksExcels]

@gibsonsimpson

I am so pleased that this video helped you. Thank you for writing to tell me.

Danny Rocks

The Company Rocks

[zenshinify]

your mouse clicks are louder than your voice. i can't watch this. look up what an audio compressor does, then use it.

[DannyRocksExcels]

@zenshinify

Thank you -

I have removed the mouse click sounds from my software recording package - this is no longer a problem

Danny Rocks

[MrWinch]

Excellent video. Very straight-forward. I would only recommend on toning down or removing th clicking sound as it is very distracting. Thanks for the tutorial, though.

[amanuelb]

good tutorial

[samirahmed42]

Very helpful video. Really makes it easy to follow.

[frenchyfrufru]

This really helped!

Thanks!!!!

[chakra123view]

nice tutorial...thanks!

[muss212]

how to use it in excel 2007, it has different function

[vasymariuss]

Thank u! :)

[Attim]

Oh wow, this really helps me out with my Excel class! I have final projects due next week. I'm definitely subscribing to your videos! Thank you so much!

[earll2001]

Turn off the click!

[phyo117]

thats brilliant

[flossysora]

well done!

[vanillalad]

great video , thanks....

[DannyRocksExcels]

Thank you! I am happy that you liked the video and that it helps you.

Danny Rocks

[dvrjosh]

This was helpful, thanks.