Mobile/PDA About Us Advertise here
User User name Password  
  Not registered yet? Register here.
Lost your password? Click here. 		 
  Home   News   Guides   Downloads   Glossary   Hardware   Profiles   Forums   v4  
 Advertise at AfterDawn.com     Link to us!     Private messages     Compose a private message     List of all updated threads     Threads without replies     Search messages
Wednesday 6.8.2025 / 04:52
Search AfterDawn Forums:        In English   Suomeksi   På svenska
afterdawn.com > forums > software, operating systems and more > windows - software discussion > excel help.
Show topics
 
Forums
Forums
Excel help.
  Jump to:
 
Posted Message
i_am_alex
Member
_ 		6. April 2008 @ 01:46 _ Link to this message    Send private message to this user   
Alright, I got basic knledge in Excel, I'm no master though. I need someone to help me make a formula, so my sheet will do the following:

When I insert the word "Yes" into H15, it will subtract 5% in J15.

If this was typed in J15: =G15*A15
I would want it to change to =G15*A15/100*95 once I type Yes into H15.

I also want the formula to stay the same if I type "No".

I tried using the IF function, but it doesn't make much sense to me.

Thanks in advance.
[ + quote]
afterdawn.com > forums > software, operating systems and more > windows - software discussion > excel help.
 

Digital video: AfterDawn.com | AfterDawn Forums
Music: MP3Lizard.com
Gaming: Blasteroids.com | Blasteroids Forums | Compare game prices
Software: Software downloads
Blogs: User profile pages
RSS feeds: AfterDawn.com News | Software updates | AfterDawn Forums
International: AfterDawn in Finnish | AfterDawn in Swedish | AfterDawn in Norwegian | download.fi
Navigate: Search | Site map
About us: About AfterDawn Ltd | Advertise on our sites | Rules, Restrictions, Legal disclaimer & Privacy policy
Contact us: Send feedback | Contact our media sales team
 
  © 1999-2025 by AfterDawn Ltd.

  IDG TechNetwork