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 colum...
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!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 :-(
Ok.
Try this formula instead:
=IF(AND(ISNUMBER(B6),ISNUMBER(C6)),IF(AND(B6<=$B$1,C6<=$B$2),"Might Buy","Won't Buy"),"")