| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yes
If I write Yes in one cell, and as soon as I write yes in Cell B, how can I
get 500 in cell B |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Yes
you can get 500 in cell b1 by typing yes in cell a1,if you have in cell b1
=if(a1="yes",500,""). if a1 is anything other than yes b1 will be blank -- paul remove nospam for email addy! "Aysha" wrote: If I write Yes in one cell, and as soon as I write yes in Cell B, how can I get 500 in cell B |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
