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
A Aysha Jun 24, 2006 #1 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
P paul Jun 24, 2006 #2 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
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
