# 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

#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 formulaThanks

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 CrossThanks for the Help.Sorry for getting back a bit lateCheers

Report •