• 412K Members
• 3,348 Online
• 468K Conversations

## How do i do functions and formulars Please

Occasional Contributor

# 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

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
Highlighted

# Re: How do i do functions and formulars Please

@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

# Re: How do i do functions and formulars Please

@TiggerD  Is this your homework assignment?

# Re: How do i do functions and formulars Please

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

# Re: How do i do functions and formulars Please

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 :-(

# Re: How do i do functions and formulars Please

@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!

# Re: How do i do functions and formulars Please

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 :-(

# Re: How do i do functions and formulars Please

@TiggerD

Ok.

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

# Re: How do i do functions and formulars Please

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

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies