Search results

Happy Diwali wishes to every one around the world. May the new year see all you formulas work and hopefully the results are what you were hoping for. And for Saturday Sal Mubarak for 1436 New Year - Hiriyah Kanti

Hi Saeed, You can use the COUNTIF formula, but you must ensure that the names are all the same. So Dr.James is not the same as Dr. James because of the space between the period and James.

Hi Lilly, Can you do a mock up of what you want and upload the workbooks. And explain what data goes from where to where. kanti

Hi Rajkenya1, Try this formula =FV(3.4%/4,4,,-100000).

Hi Falina, Nebu is correct, in order to calculate the ROI you need the Annual Balance Sheet and Income Statement. You have given no indication to the assets employed to generate income and cash flow.

Basically you have to convert the rate compounded daily to a rate compatible with your repayment period. So here you must convert the 10% annual rate compounded daily to monthly rate, and then apply the new rate to the PMT formula. If you 10,000 principal, 10% pa compounded daily, to convert...

Try this, hit Ctrl End on each sheet, this should take you to the last used cell on the sheet. If the result is beyond the actual range you should Delete extra the Columns and/or Rows Another problem could be the extensive use of formatting, this usually blows out the size of the file

Hi Jack, Not sure if you have tried Trace Precedents and Trace Dependents, both can be found on the Formula Tab cheers kanti

Check out this link http://stackoverflow.com/questions/10995917/excel-convert-calendar-week-into-date

Hi, Have changed the formula, please check =IF(COUNTIF(C2:M2,">600"),FALSE,TRUE) kanti

Hi Jaimee, I have put the formula in the attached file. In N2 you have =IF(COUNTIF(C2:M2,">600"),TRUE,FALSE)

Hi Ruthie, here i an alternate solution, your data must be sorted on the Product Column kanti

Hi Buckai, Your data is TEXT and not a number. If you want the $ sign, you can format a number as Currency. I have made one change in the file. kanti

Hi Shahul, please refer to the following: http://www.contextures.com/xlDataVal02.html cheers kanti

Please attach the file with the problem, have you confirmed that you are using the correct parameter as the last parameter in the vlookup statement

Sorry Jack, been out of touch, please upload the file and let me test it

Hi Jack, Look at the attached file, I have used the data from your file, please look at the structure of the data, you will note that I have inserted a couple of rows at the top, the data starts in Column A, the columns G through to AW have been copied down to all rows EXCEPT the last row...

Hi Jack, Let me have the file you are running it on to test

Hi Larry, Not sure what file you have, but this is the latest file that I have. Please try it and let me know if you still have problems. cheers kanti

Thanks for picking this up Fasseh

Hi Jack, Will revisit this on Monday

Hi, Look at the attached file, it uses a Named Range and the Vlookup function. kanti

I got this in an email from Charles Kyd I got the time wrong about the Microsoft event. Also many people were unable to connect to the Microsoft blog. So here's the exact announcement from Microsoft: "Join us Friday, April 4 at 1:00pm PDT/4:00pm EDT for the first Excel-hosted AMA (what’s an...

Hi Jeo, No problem glad to help, in future please add your comments to the original post.

Look at the uploaded file