Help i am trying to create formula

Microsoft Office 2007 home and student
February 27, 2012 at 05:44:32
Specs: Windows XP
how can i create a formula to produce a tick, i.e if i have a sum of 1.5 in cell A, and 1.2 in cell B, and cell C should show a tick if Cell is higher than cell B and cross if cell A is Lower than cell B. Thank You

See More: Help i am trying to create formula

Report •

#1
February 27, 2012 at 08:57:54
What's a "tick" and what's a "cross"?

You could use a simple IF function and then format the cell with a font that gives you the "symbols" that you need based on whatever characters you use in the function.

BTW...what happens if cell A equals cell B?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 27, 2012 at 23:21:22
I Know a Tick and a Cross as this √ and ×, How do you know it?

But how would I set up the formula as i dont know how to set up and what to include in that formula

Thanks


Report •

#3
February 28, 2012 at 04:55:16
Read up on the IF function in the Excel help files or via Google.

However, you didn't answer my question:

What happens if Cell A equals Cell B?

You asked about "greater than" and "less than", but depending on how you write the IF function, you could get a result that you don't want if Cell A equals Cell B. Do you want a tick or a cross or something else in that case?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
February 28, 2012 at 05:40:32
Is this what you are looking for in C1?

=IF(A1>B1,"√","X")

NB: You can insert check mark in excel worksheet but not within excel formula.


Report •

#5
February 28, 2012 at 11:21:07
Nabam,

The problem with your suggestion is that the OP wants an X when "cell A is Lower than cell B."

Using your suggestion, the result will also be an X when the cell A equals cell B.

Until the OP responds to my question on how to handle "cell A equal to Cell B", I'm not sure it makes sense to offer a suggestion. The quality of the response is dependent on the quality of the question and I don't think that we have all of the information we need yet.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
March 6, 2012 at 04:11:13
Hi Guys,

I am Trying to create a formula as follows. Example: Cell A = 1.5 Cell B = 1.2 Cell C should how Tick, as Cell A is greater than Cell B, If Cell B is Greater than Cell A. Then Cell C should show Cross. if Cell A,B Equal then Cell C should show Cross.

If Possible can Cell C fill Red or Green. Green when ticked, Red when Cross

Thanks for the Help.

Sorry for getting back a bit late

Cheers


Report •

Ask Question