Question description:
This user has given permission to use the problem statement for this
blog.
A1= 19.13
B1= FLAT
C1= Formula =IF(A1<=20,"PASS","FAIL")
However if B1=House the formula required is as follows
=IF(A1<=30,"PASS","FAIL")
How do I write the formula in C1 to take account of the variation in cell B1?
Solved by V. D. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
24/11/2017 - 01:18
Hello, welcome to Got It Pro
Excelchat Expert
24/11/2017 - 01:18
How may I help you today?
User
24/11/2017 - 01:19
Hi
Excelchat Expert
24/11/2017 - 01:21
Done
User
24/11/2017 - 01:21
B16 & B17 say FLAT and House respectively
Excelchat Expert
24/11/2017 - 01:21
Please check cell C1 now
Excelchat Expert
24/11/2017 - 01:21
I have changed formula
Excelchat Expert
24/11/2017 - 01:21
Check cell C1 now
User
24/11/2017 - 01:21
The answer to the B colum dictates the formula to be used.
Excelchat Expert
24/11/2017 - 01:22
Let me know if you have any doubt
Excelchat Expert
24/11/2017 - 01:23
??
User
24/11/2017 - 01:23
Hi thanks.......I've added the formula to my spreadsheet but I'm getting fail when I should be getting pass
Excelchat Expert
24/11/2017 - 01:24
In which case?
Excelchat Expert
24/11/2017 - 01:24
tell me the value in cell A1 and B1 for which you are getting wrong result
User
24/11/2017 - 01:24
If you look at C16 & C17
Excelchat Expert
24/11/2017 - 01:25
Ok
Excelchat Expert
24/11/2017 - 01:25
What happend?
User
24/11/2017 - 01:26
Sorry this is my first time using this website and I'm not very good at excel, bear with me.
Excelchat Expert
24/11/2017 - 01:27
That's ok, no problem :)
Excelchat Expert
24/11/2017 - 01:27
Just tell me, where you are stuck?
User
24/11/2017 - 01:28
Got it working now.......sorry I was being a bit dumb
User
24/11/2017 - 01:28
Thanks for your help, it is greatly appreciated!
Excelchat Expert
24/11/2017 - 01:28
Thanks
Excelchat Expert
24/11/2017 - 01:28
Have a great day :)
Excelchat Expert
24/11/2017 - 01:29
Please leave your valuable feedback :)
User
24/11/2017 - 01:29
You too. Your a star.
User
24/11/2017 - 01:29
How do I do that?
Excelchat Expert
24/11/2017 - 01:29
You may close the session now from above :)
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.