How do i do functions and formulars Please

[TiggerD]

Hi everyone, 

I am trying to do a task in a spreadsheet, and I am struggling with it.

Budget is £10,000 and the miles are 20,000

So, I need to do the following 

Add a formula in column D such that it shows “Might Buy” if a car meets both
criteria and “Won’t Buy” if it does not.

Add conditional format to column D so that “Might Buy” appears in green and
“Won’t Buy” appears in grey.

I am totally lost; I am getting myself so mixed up that I wish I had never started it :smiling_face_with_smiling_eyes:

Any help will be very much appreciated :smiling_face_with_smiling_eyes: :smiling_face_with_smiling_eyes:

[#2]

@TiggerD

Hi,

You need a formula along with two conditional formatting rules.

This is the formula I suggest:

=IF(AND(ISNUMBER(B2),ISNUMBER(C2)),IF(AND(B2=$G$2,C2=$G$3),"Might Buy","Won't Buy"),"")

 

With regards to the Conditional Formatting, you need these two formulas in two separate rules and apply them to the column D.

=D2="Won't Buy"

=D2="Might Buy"

Please see that in the attached file.

Hope that helps

[#3]

@TiggerD  Is this your homework assignment?

[#4]

@Ingeborg Hawighorst 

No it is a task I have been given to do, I need to learn this but just cant get my head around it, I have tried so many different ways :( 

I have even done the one above and it didn't work for me 

[#5]

Hi 

Thank you for replying, I have tried it and it didn't work for me, I am totally brain dead now as it works for other but not me :( 

[#6]

@TiggerD

Hi,

What's wrong with it?

Please explain the problem you encountered!
It's best to give us a sample of the worksheet you're working on!

[#7]

@Haytham Amairah 

Hi, 

I did what you had put and it was putting things in over 20,000 miles, I have tried several times, I guess it is something I am doing wrong :( 

[#8]

@TiggerD

Ok.

Try this formula instead:

=IF(AND(ISNUMBER(B6),ISNUMBER(C6)),IF(AND(B6<=$B$1,C6<=$B$2),"Might Buy","Won't Buy"),"")

[#9]

@Haytham Amairah Thank you so much for the help you have given me