thanks rmeyer for your help but a need a bit more if possible. here is an example hope it makes sense, cell b2 =if(a1=1,"25")
now what i want to do is say i put a 1 in cell a1 i know cell b2 will show 25, but if i put a 2 into cell a1 is it possible to add to the formula in cell b2 so that the answer in cell b2 would be say 10, so how can i write the formula so the different figure i put into cell a1 will give me a different answer in cell b2. Cheers for any help in advance.
Tags: