A = abc

punit83

New Member
Joined
Jan 17, 2018
Messages
21
Hello

i want a formula for follwing
if in cell A1 i type I = than in B1 answer should be display myself
if in cell A2 i type u = than in B2 answer should be display yourself


Thanks in advance
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
31,987
Office Version
365
Platform
Windows
In B1 put =IF(A1="I","myself","")
& in B2 put =IF(A2="u","yourself","")
 

punit83

New Member
Joined
Jan 17, 2018
Messages
21
thanks for reply

and if i want a formula for follwing
if in cell A1 i type I = than in B1 answer should be display myself
if in cell A1 i type u = than in B1 answer should be display yourself
 

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
5,146
Hi,

I think this is what you mean:

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">i</td><td style=";">Myself</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">u</td><td style=";">Yourself</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;;"></td><td style=";"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">s</td><td style=";"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">I</td><td style=";">Myself</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">U</td><td style=";">Yourself</td></tr></tbody></table><p style="width:5.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet31</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B1</th><td style="text-align:left">=IF(<font color="Blue">A1="I","Myself",IF(<font color="Red">A1="U","Yourself",""</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
 
Last edited:

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,498
Office Version
2010
Platform
Windows
thanks for reply

and if i want a formula for follwing
if in cell A1 i type I = than in B1 answer should be display myself
if in cell A1 i type u = than in B1 answer should be display yourself
Put this formula in cell B1...

=IF(A1="I","myself",IF(A1="u","yourself",""))
 

Forum statistics

Threads
1,081,537
Messages
5,359,380
Members
400,526
Latest member
Brook1083

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top