Hi,
Thank you for the reply. I have already tried doing this. This does not work since the entries in E5 and E3 will be done subsequent to the formula entry in E10 (Since its a financial projection sheet). I was just wondering is there any other way of doing this like writing in VBA?
hi,
I have a cell which has a formula. I need to validate the formula result such that if a user inputs a number in the formula source cell and if the formula result is 10% more or less than the average of previous two cells a message box appears saying that it is an incorrect entry.
For...
Hi all,
I am Padmaja from India. Currently working as Analyst. Interested in excelling in excel, i googled and bang.. i discover chandoo.org.
Happy to be here to learn ..
Regards