Tick mark to display word

**DODGE** · 05-30-2011, 06:07 AM

Hi Guys
Can anybody help me with this formula.
I have to headings called DOORS AND DRAWERS.
Under doors is cell E10 and Under Drawers is cell F10
Across my page I have the heading INFO and the cell under this is cell Q10.
When I place a tick mark in cell E10 I want the cell Q10 to say DOORS
And when I place the tick mark in cell F10, I want Q10 to say DRAWERS
I am using the font Wingdings 2 with a capital P to get the tick mark so I don’t want the letter P
To come across to cell Q10.
Thanks Guys
Dodge

**pike** · 05-30-2011, 07:17 AM

DODGE
what if you place a tick in cell E10 and F10, what is in cell Q10 ?

**DODGE** · 05-30-2011, 07:34 AM

Originally Posted by pike

DODGE
what if you place a tick in cell E10 and F10, what is in cell Q10 ?

Hi Pike
I want to place a tick mark in E10 OR F10 Then Q10 will display the word either DOORS or DRAWERS.
Is there a formula to do this?
Cheers Dodge

**pike** · 05-30-2011, 07:41 AM

hmmm
in Q10
=if(e10="P","Door",if(f10="P","Dawer",""))

**DODGE** · 05-30-2011, 08:09 AM

Originally Posted by pike

hmmm
in Q10
=if(e10="P","Door",if(f10="P","Dawer",""))

Thanks Pike
Works like a dream thanks heaps.
Dodge

**pike** · 05-31-2011, 02:11 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save