# Excel - IF Function Problem - Expert Solution

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
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
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
User 24/11/2017 - 01:29
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.

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.