Jun 24 2019 10:26 AM
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:
Jun 24 2019 10:50 AM
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
Jun 24 2019 02:40 PM
@TiggerD Is this your homework assignment?
Jun 25 2019 03:18 AM
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
Jun 25 2019 03:20 AM
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 :(
Jun 25 2019 10:26 AM
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!
Jun 25 2019 11:41 AM
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 :(
Jun 25 2019 11:58 AM
Ok.
Try this formula instead:
=IF(AND(ISNUMBER(B6),ISNUMBER(C6)),IF(AND(B6<=$B$1,C6<=$B$2),"Might Buy","Won't Buy"),"")
Jun 26 2019 11:46 AM
@Haytham Amairah Thank you so much for the help you have given me