My question is lets say I want to get the sum of A1 and A2 and send the sum
to cell B5. How do I send or change the value of a cell without having my
equation in that cell.

another example my be that I do and IF statement and if I get a certain
result I want to clear cell B5. How do I do this please!

Thanks.