| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't know what I need to do!
Hi guys, I have no idea what I'm trying to do so I couldn't put it in the thread title! Basically I have a dropdown menu on a column from which you can choose A, B or C If you select A, I want 900 to appear in the adjacent cell If you select B, I want 1,000 to appear in the adjacent cell If you select C, I want 1,200 to appear in the adjacent cell. So far I've got this... =IF(AA2="A","900","") but I can't figure out how you can link these together so it will return a value for all 3 selections. I think this is very simple and I'm sure I've done it before, but it's driving me mad! Thanks everyone! -- monkeydan ------------------------------------------------------------------------ monkeydan's Profile: http://www.excelforum.com/member.php...o&userid=36982 View this thread: http://www.excelforum.com/showthread...hreadid=567038 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I don't know what I need to do!
=IF(AA2="A",900,IF(AA2="B",1000,1200))
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "monkeydan" wrote in message ... Hi guys, I have no idea what I'm trying to do so I couldn't put it in the thread title! Basically I have a dropdown menu on a column from which you can choose A, B or C If you select A, I want 900 to appear in the adjacent cell If you select B, I want 1,000 to appear in the adjacent cell If you select C, I want 1,200 to appear in the adjacent cell. So far I've got this... =IF(AA2="A","900","") but I can't figure out how you can link these together so it will return a value for all 3 selections. I think this is very simple and I'm sure I've done it before, but it's driving me mad! Thanks everyone! -- monkeydan ------------------------------------------------------------------------ monkeydan's Profile: http://www.excelforum.com/member.php...o&userid=36982 View this thread: http://www.excelforum.com/showthread...hreadid=567038 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I don't know what I need to do!
Hi Bob, thanks for your help; I guess we posted at the same time. I have another question for everyone - Can you format cells according to the value in another cell? In the first cell you can select whether you want to choose a region in the UK or a region in Ireland. If you select the UK, cells after that should be formatted with a £ sign. If you select Ireland, cells after than should be formatted with a EURO sign (which I can't seem to find on my keyboard!) -- monkeydan ------------------------------------------------------------------------ monkeydan's Profile: http://www.excelforum.com/member.php...o&userid=36982 View this thread: http://www.excelforum.com/showthread...hreadid=567038 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I don't know what I need to do!
And following on from the above, I want the formula in the second post to also contain EURO values if 'Ireland' is selected in the first cell. I guess this will use the AND function but as you are no doubt now aware, I'm not too hot on Excel. Thanks for any help you can give me. -- monkeydan ------------------------------------------------------------------------ monkeydan's Profile: http://www.excelforum.com/member.php...o&userid=36982 View this thread: http://www.excelforum.com/showthread...hreadid=567038 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I don't know what I need to do!
OK, disregard the two questions above as I'm now aware you can't format cells to that degree using conditional formatting (although please feel free to enlighten me if I'm incorrect!) However, I now have another question... I have a list of postcodes which correspond to a certain value (AB). If cell O2 contains one of the postcodes in the list (on sheet 2), I want cell AN to display 'AB'. If the postcode in O2 does not appear on the list, I want cell AN to display "CD" At the moment, I've got this formula in cell AN2... =IF(O2=SHEET2!A2:A190),"AB","CD") But everything is returning CD, regardless of whether cell O2 contains a postcode within A2:A190 or not. Can anyone help?! -- monkeydan ------------------------------------------------------------------------ monkeydan's Profile: http://www.excelforum.com/member.php...o&userid=36982 View this thread: http://www.excelforum.com/showthread...hreadid=567038 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I don't know what I need to do!
remove the bracket after A190 -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=567038 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I don't know what I need to do!
=IF(ISNUMBER(MATCH(O2,SHEET2!A2:A190)),"AB","CD") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "monkeydan" wrote in message ... OK, disregard the two questions above as I'm now aware you can't format cells to that degree using conditional formatting (although please feel free to enlighten me if I'm incorrect!) However, I now have another question... I have a list of postcodes which correspond to a certain value (AB). If cell O2 contains one of the postcodes in the list (on sheet 2), I want cell AN to display 'AB'. If the postcode in O2 does not appear on the list, I want cell AN to display "CD" At the moment, I've got this formula in cell AN2... =IF(O2=SHEET2!A2:A190),"AB","CD") But everything is returning CD, regardless of whether cell O2 contains a postcode within A2:A190 or not. Can anyone help?! -- monkeydan ------------------------------------------------------------------------ monkeydan's Profile: http://www.excelforum.com/member.php...o&userid=36982 View this thread: http://www.excelforum.com/showthread...hreadid=567038 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I don't know what I need to do!
Wow, am I a dumbass or what? =IF(AA2="A",900,IF(AA2="B",1000,(IF(AA2="C",1200)) )) I have figured it out - I wasn't using the brackets properly and re-using the 'IF' between each value. So I have succeeded! -- monkeydan ------------------------------------------------------------------------ monkeydan's Profile: http://www.excelforum.com/member.php...o&userid=36982 View this thread: http://www.excelforum.com/showthread...hreadid=567038 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
