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 |
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 |
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 ! |
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 ! |
All times are GMT +1. The time now is 05:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com