**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.*