Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula that when a manually typed in percentage to Cell A1 is above 80 populates cell B2 with 100% and when A1 is less than 80 populates cell B2 with the actual percentage For example if A1 is 75% then B2 shows 75% If A1 is 95% then B2 shows 100%
Solved by E. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 13/08/2018 - 01:04
Hi there!
Excelchat Expert 13/08/2018 - 01:04
You've described your problem perfectly and I will be happy to help.
Excelchat Expert 13/08/2018 - 01:05
One question before I begin - is cell A1 formatted as a %? As in, if you type in say 82, will it show 82%?
User 13/08/2018 - 01:06
yes but then i need b2 to show 100% in that scenario
Excelchat Expert 13/08/2018 - 01:06
Gotcha - no problem
Excelchat Expert 13/08/2018 - 01:06
Give this a try and let me know if it works for you:
Excelchat Expert 13/08/2018 - 01:06
User 13/08/2018 - 01:06
and now it A1 was less than 80 say 75
User 13/08/2018 - 01:06
it will show 100
Excelchat Expert 13/08/2018 - 01:06
That would go into cell B2
User 13/08/2018 - 01:06
User 13/08/2018 - 01:07
Thank you
Excelchat Expert 13/08/2018 - 01:07
Please feel free to reach back out to us with a new session if you need more help and we will be happy to assist!
Excelchat Expert 13/08/2018 - 01:07
Have a great day and all the very best to you ~
Excelchat Expert 13/08/2018 - 01:07
You're welcome!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc