Could I ask you to explain why in Excel 2003 (sorry I know it's years ago now) when I copy-paste formulas it pastes the values as well?
I am trying to weight a forecast over a few days and just having trouble with the formula. Can anyone help. The scenario is as follows
Sales
Monday I do 24% of my sales, Tuesday I do 76%
If I did $100,000 in sales and wanted to weight the sales so I have a cumulative total after each day how would I do this based on the following days
Tuesday
Monday
Tuesday
Monday
Dear M.s. Beauty,Do you knows if there is a way (add-in or whatever) to get a number converted into words? For instance if I write 121 get it "translated" to one hundred twenty one in excel sheet.kindly advice on this matter i am prepaing Financial modillingMuwahh &ThanksAhmedS.Oman
I have attended a Financial Modelling course with Danielle in Kuala Lumpur and I would like to seek your help on SUMIF function.
How do I use SUMIF, should I have 2 criterias to fulfil?
I have attached a copy of some data for illustration.
Let's say I have Criteria 1 : Alor Setar; and Criteria 2 : MONTH
How do I go about it?
Thanks.
Regards,
Mandy
Hi Danielle,
I’ve tried various formulas but couldn’t get the right answer. Can you help?
Imagine the below is in an Excel sheet. I'd like a formula to pick up the distance from Banting to Kuala Lumpur, for example. How can I do this?