| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create If statement that returns a tick when true
Hi,
I would like to show a tick in a cell if the value of the cell alongside is equal to one. I can put a tick in a cell using Insert-Symbol-change font to Wing- Dings and select the tick. However, if I now try to put a If statement around this tick (which shows as a P in the cell) everything shows as Wing Ding characters. Any idea how I can have an If statement that returns a tick when statement is true. Thanks, Tom |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create If statement that returns a tick when true
I don't know if I quite understand your problem.
Format B1 to Wingdings2 and enter this formula into it: =IF(A1=1,"P","") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message ups.com... Hi, I would like to show a tick in a cell if the value of the cell alongside is equal to one. I can put a tick in a cell using Insert-Symbol-change font to Wing- Dings and select the tick. However, if I now try to put a If statement around this tick (which shows as a P in the cell) everything shows as Wing Ding characters. Any idea how I can have an If statement that returns a tick when statement is true. Thanks, Tom |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create If statement that returns a tick when true
On Nov 7, 1:45 pm, "RagDyer" wrote:
I don't know if I quite understand your problem. Format B1 to Wingdings2 and enter this formula into it: =IF(A1=1,"P","") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message ups.com... Hi, I would like to show a tick in a cell if the value of the cell alongside is equal to one. I can put a tick in a cell using Insert-Symbol-change font to Wing- Dings and select the tick. However, if I now try to put a If statement around this tick (which shows as a P in the cell) everything shows as Wing Ding characters. Any idea how I can have an If statement that returns a tick when statement is true. Thanks, Tom- Hide quoted text - - Show quoted text - Fantastic thanks ! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create If statement that returns a tick when true
Appreciate the feed-back.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- wrote in message ps.com... On Nov 7, 1:45 pm, "RagDyer" wrote: I don't know if I quite understand your problem. Format B1 to Wingdings2 and enter this formula into it: =IF(A1=1,"P","") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message ups.com... Hi, I would like to show a tick in a cell if the value of the cell alongside is equal to one. I can put a tick in a cell using Insert-Symbol-change font to Wing- Dings and select the tick. However, if I now try to put a If statement around this tick (which shows as a P in the cell) everything shows as Wing Ding characters. Any idea how I can have an If statement that returns a tick when statement is true. Thanks, Tom- Hide quoted text - - Show quoted text - Fantastic thanks ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any number above 15 returns false when it should be true | Excel Worksheet Functions | |||
| An if statment tat returns a true blank | Excel Worksheet Functions | |||
| how to create a if statement, if true turn colour | Excel Worksheet Functions | |||
| If Statement returns true when false? | Excel Discussion (Misc queries) | |||
| Code returns TRUE instead of value | Excel Discussion (Misc queries) | |||
Linear Mode
