Dear Members,
I have prepared the model and its working perfectly fine as per the technicalities . The only issue which i am facing right now is whicle testing the formulas and model, if i remove one cell or delete which is linked to the other formulas just to check what happens then it shows...
Thanks Hui, Basically its a financial model where i provide inputs like tariff rate and whole model drives on the basis of it. Cost which is given is also constant. However when i run the sensitivity analysis on range of tariff rate, it shows results till a particular tariff rate and then shows...
This is basically when i am running sensitivity analysis on different tariff rates to check IRR on them and when IRR at a particular valye goes below 0%, it shows #NUM!.
Dear Members,
While running the sensitivity analysis, there are few output numbers which are negative in excel are shown as # Num!. how can i have the negative number display as it is instead of showing #Num!
Its urgent, can any one help/
Regards
Saad
i mean to say that if some one else is working on the model and by mistake he enters anything other than number than it shows the error but when u cancel it, then u see #value in output cells. how we should rectify this error
I have applied data validation on the input cells to accept only the numbers by applying =isnumber(Cell number) which is working quite fine. but the problem which i am facing currently is when i try to put any thing other than number then it gives error that it can not accept it but when i...
Dear Members,
I have created the file which had different name of process owners along with their targets. i dont want to create seperate files for all of them but at the same time i dont want them to see each others targets. When i send the file to the particular owner then he shouuld not be...
My boss has told me to run the sensitivity analysis to see the range of traiff rate at which we maintain the current margins. How is it possible to show the changing tariff rate without changing the current margins. Its a 30 year project and being conservative we have one tariff rate and we have...
It is only showing "unexpected error has ocurred ". Thats what is written on dialogue box. I cant post anything s all sites are blocked in office. But that is the only thing written in box
While creating the hyperlink in excel, i am getting the unexpected error. What is the cause of it. Whenever i click on the hyperlink, it says unexpected error .
Please guide
Regards
Saad
how can i have a number along with the text in the cells which can be calculated. suppose how can i write INR 500 and INR 300 in two different cells and still apply calculations on them. For that matter any text along with number
Regards
Saad
Dear members,
I have made the cover page of my model and now i want to diable it. I mean if someone clicks on it then he cant click it or change it. He should not get the feeling that there are cells in it. He is niether able to change it or click on it. Just can see it
regards
Saad
I have prepared the coverpage for my model which says the name of the company, logo of the company and name of the project. My boss says it looks like excel, try to make it more impressive so it looks professional. What shall i do, how to make it look and not like excel :)
Regards
Saad
I would like to add a print button on excel sheet, so i can click it and sheet gets printed. What code should io assign to button if name of button is PRINT. Please suggest
Regards
Saad
I just want to show the chart and not the data from the summary sheet but want to keep the data on the same page. when i am hiding the data then chart does not show up anything. Any way to hide the data on the same page and show the graph.
regards
saad
Dear Members,
I would like to have button on each of my worksheet which takes me to the index page of the model. what kind of coding do i need to do for this.
Regards
Saad
Dear Members,
I have almost completed my Model and would like to design it so it doesnt look like excel. I wanna make it look like forms. Is there any way to do it or any other way through which it looks very professional.
Regards
Saad