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

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