| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple IF
Hi everyone... I have a question ! Sheet1: A1 (input) A2, A3, A4, A5 (here I need to get a number 1 depending on input in A1. If I put in A1 : *G* I will get number 1 in A2 *V* I will get number 1 in A3 *VP* I will get number 1 in A4 *C* I will get number 1 in A5 ) -- alen_re ------------------------------------------------------------------------ alen_re's Profile: http://www.excelforum.com/member.php...o&userid=28331 View this thread: http://www.excelforum.com/showthread...hreadid=503607 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple IF
alen_re Wrote: Hi everyone... I have a question ! Sheet1: A1 (input) A2, A3, A4, A5 (here I need to get a number 1 depending on input in A1. If I put in A1 : *G* I will get number 1 in A2 *V* I will get number 1 in A3 *VP* I will get number 1 in A4 *C* I will get number 1 in A5 ) See if the following will work for you: In Cell A2: =if(A1="G",1,"") In Cell A3: =if(A1="V",1,"") In Cell A4: =if(A1="VP",1,"") In Cell A5: =if(A1="C",1,"") Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=503607 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple IF
Thanks a lot.. This is answer to my question.. Simple.. but when you don't know.. :) Thanks again... -- alen_re ------------------------------------------------------------------------ alen_re's Profile: http://www.excelforum.com/member.php...o&userid=28331 View this thread: http://www.excelforum.com/showthread...hreadid=503607 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple IF
You are welcome ... just glad I can help. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=503607 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External Links and Multiple Instances | Excel Discussion (Misc queries) | |||
| view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
Linear Mode
