Forum Discussion
How do i do functions and formulars Please
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 😊
Any help will be very much appreciated 😊 😊
8 Replies
TiggerD Is this your homework assignment?
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
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
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 :-(
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!
