| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Allocating a value from a cell
Hi, Is there any way to allocate a value to a cell depending what is in another cell, so if A1=yes then A2=5 or B1=no then B2=10 Hope that makes sense Thanks, -- babygoode ------------------------------------------------------------------------ babygoode's Profile: http://www.excelforum.com/member.php...o&userid=26109 View this thread: http://www.excelforum.com/showthread...hreadid=394367 |
|
#2
|
|||
|
|||
|
A2 = IF(A1="yes",5) B2 = IF(B1="no",10) babygoode Wrote: Hi, Is there any way to allocate a value to a cell depending what is in another cell, so if A1=yes then A2=5 or B1=no then B2=10 Hope that makes sense Thanks, -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=394367 |
|
#3
|
|||
|
|||
|
Sure You would put this in A2:
=IF(A1="Yes",5,"") and this in B2: =IF(B1="No",10,"") Brian "babygoode" wrote: Hi, Is there any way to allocate a value to a cell depending what is in another cell, so if A1=yes then A2=5 or B1=no then B2=10 Hope that makes sense Thanks, -- babygoode ------------------------------------------------------------------------ babygoode's Profile: http://www.excelforum.com/member.php...o&userid=26109 View this thread: http://www.excelforum.com/showthread...hreadid=394367 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
