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
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"),"")
Haytham Amairah Thank you so much for the help you have given me