Question description:
This user has given permission to use the problem statement for this
blog.
If b22 is >.55*d22 and less than .75*d22. How do I write this formula?
Solved by S. S. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
28/07/2018 - 02:49
Hi
Excelchat Expert
28/07/2018 - 02:49
Welcome to Got it pro
User
28/07/2018 - 02:49
Hello, I really need your help with this formula
Excelchat Expert
28/07/2018 - 02:49
Sure.
User
28/07/2018 - 02:50
Thank you
Excelchat Expert
28/07/2018 - 02:50
Do you have any excel sheet?
User
28/07/2018 - 02:50
That is what I need it for
Excelchat Expert
28/07/2018 - 02:50
ok.
Excelchat Expert
28/07/2018 - 02:50
.55 or 55?
User
28/07/2018 - 02:50
55%
Excelchat Expert
28/07/2018 - 02:51
Oh ok.
Excelchat Expert
28/07/2018 - 02:51
First we would like to check whether B22 > 55%
Excelchat Expert
28/07/2018 - 02:51
if Yes you would like to multiply with d22 is it?
Excelchat Expert
28/07/2018 - 02:52
As per my understanding you would like B22 is greater than 55%*d22 and it should be less than 75% *D22 is it?
Excelchat Expert
28/07/2018 - 02:53
What will be the value in D22?
Excelchat Expert
28/07/2018 - 02:54
=and(B22>0.55*D22,B22<0.75*D22)
User
28/07/2018 - 02:54
I'm trying to make a range between b12 and d22. If d22 is greater than 55% of b12, but less than 75% of b12
Excelchat Expert
28/07/2018 - 02:54
Ok I request you to create sample data in the excel
Excelchat Expert
28/07/2018 - 02:57
is it fine?
Excelchat Expert
28/07/2018 - 02:57
Are you there with me?
Excelchat Expert
28/07/2018 - 02:57
My B12 value is 200
User
28/07/2018 - 02:57
yes i am
Excelchat Expert
28/07/2018 - 02:57
D22 Value is 122
Excelchat Expert
28/07/2018 - 02:58
Since its >0.55 *B12 and <0.75 *B12 it will give you true
Excelchat Expert
28/07/2018 - 02:58
Else it will be false
Excelchat Expert
28/07/2018 - 02:59
Is it fine?
User
28/07/2018 - 02:59
Im inputting it into the conditional formatting for a color range.
Excelchat Expert
28/07/2018 - 03:00
ok.If it true it will give you one color else another color
User
28/07/2018 - 03:00
Yes
Excelchat Expert
28/07/2018 - 03:00
wait
Excelchat Expert
28/07/2018 - 03:00
I will modify
Excelchat Expert
28/07/2018 - 03:03
FYI
[Uploaded an Excel file]
Excelchat Expert
28/07/2018 - 03:03
Please download this file and Check
Excelchat Expert
28/07/2018 - 03:05
Are you there?
Excelchat Expert
28/07/2018 - 03:05
FYI. How to apply in conditional formatting
[Uploaded an Excel file]
Excelchat Expert
28/07/2018 - 03:06
Are you there with me?
User
28/07/2018 - 03:07
It's still not working to change the color
Excelchat Expert
28/07/2018 - 03:07
Can you please my excel sheet
User
28/07/2018 - 03:08
Im not sure of what you are asking me to do
Excelchat Expert
28/07/2018 - 03:08
Ok. Now Please check our screen
Excelchat Expert
28/07/2018 - 03:09
Are you able to see the output or not?
Excelchat Expert
28/07/2018 - 03:10
Are you there?
User
28/07/2018 - 03:10
Im sorry I still here
Excelchat Expert
28/07/2018 - 03:10
yes. Please tell me
Excelchat Expert
28/07/2018 - 03:10
Is it output correct or not?
Excelchat Expert
28/07/2018 - 03:11
Or do you need any clarification?
User
28/07/2018 - 03:11
I'm pretty new to this so im not sure.
User
28/07/2018 - 03:11
I definitely need clarification
Excelchat Expert
28/07/2018 - 03:11
no issues. Please check whether output is correct or not
Excelchat Expert
28/07/2018 - 03:12
you asked me to change the color
Excelchat Expert
28/07/2018 - 03:12
I changed the color based on your condition
Excelchat Expert
28/07/2018 - 03:13
Can you please ask me your question?
User
28/07/2018 - 03:13
where would I input this information? would it still be in the conditional formatting?
Excelchat Expert
28/07/2018 - 03:13
yes..
Excelchat Expert
28/07/2018 - 03:13
[Uploaded an Excel file]
Excelchat Expert
28/07/2018 - 03:14
Are you using Excel or Google Sheet?
Excelchat Expert
28/07/2018 - 03:14
I sent you the screenshot how to apply conditional formatting in excel sheet
User
28/07/2018 - 03:14
Excel
Excelchat Expert
28/07/2018 - 03:14
then you can refer the screenshot
User
28/07/2018 - 03:14
ok let me try it out
Excelchat Expert
28/07/2018 - 03:15
Home-- conditional formatting- Newrule--
Excelchat Expert
28/07/2018 - 03:15
Use a formula to determine the cells to format
User
28/07/2018 - 03:15
ok
Excelchat Expert
28/07/2018 - 03:15
=and(D22>(0.55*B12),D22<(0.75*B12))
Excelchat Expert
28/07/2018 - 03:16
Paste this formula and select color you would like to apply
User
28/07/2018 - 03:17
ok
Excelchat Expert
28/07/2018 - 03:18
Ok.
Excelchat Expert
28/07/2018 - 03:21
Is it working?>
Excelchat Expert
28/07/2018 - 03:22
Did you download my image?
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.