Search results

Hello, Please refer attached file http://speedy.sh/DBCFQ/Formual-to-calculation-Commission.xls I would like to get a formula to calculate commission based on a sliding scale table shown in the file. Any help will be greatly appreciated. Regards, Dumbo

THanks Indian and Kevin. Appreciate your help.

HI Indian...Thanks for your reply. I applied your formula and it came up with #NAME error. Please advise

Hello Dear Friends, Could you please refer the attached spreadhseet below and kindly suggest a formula to lookup sales values using 3 conditions. http://speedy.sh/eT9xa/LookUP-Formula-with-mutiple-conditions.xls Thanks heaps Excel Dumbo

THanks GC Excel and Narayan for your answers. Hi Narayan, I have not yet installed EDATE function. Will defintely look in to it. Thanks

Hello, I need a formula to help in doing conditional formatting for date say for Example- Date given is 25/02/2012 When this date has only one month left to cross one year, that is,if today's date is 25/01/2013, it should turn yellow and when this date crosses one year,that is, if today's...

hello, please refer the attached worksheet. I would like to get a formula that will give the total number of units sold of a particular product for a particular price . http://speedy.sh/K7fUw/Book1.xls Thanks

HI Hui, Thanks for your input. I tried the above formuala. It is giving me #NA please see link below http://speedy.sh/3xssQ/permanent-link-to-column-name-in-formulav2.xls Regards

Hello , I had added the below formula =IF(ISERROR(' Netinv.sls'/Netinv.qty),"",' Netinv.sls'/Netinv.qty) in to the caculated field for a pivot table. Where there are no values for Net inv.sls and Net inv.qty columns of the pivot table, the result for the above formula appears as #Value...

hi hui, the table is actually a pivot table. I noticed when i change the pivot table structure, the external calculations go haywire. IF the formula was looking at cell#C2 which has sales dollars, when i restructure the pivot to include additional column, the formula will look at still look at...

Hello, Please find attached file http://speedy.sh/trYnv/Book1.xls I have a formula in which the references are cell numbers. I would like to permanently link the references to column names, so when i add/delete columns the references in the formula will not change. thanks Excel Dumbo

Any help please

Hello Attached is a pivot table with multiple consolidation ranges. I would like to insert two additional columns naming them Growth (2012 over 2011) and Growth (2012 over 2011) Growth(2012 over 2011) will be dividing values in Column D by Column C values Growth (2013 over 2012) will be...

thanks narayan. it worked. thanks heaps

Thank you for your reply Narayan. I tried the above formula. There is an instance where when i divide $780 (product revenue cell# J43) by 0 (quantity cell# J514), i get the answer as $780 instead of blank answer. Kindly check the file below...

Thanks a lot Narayan. I thought you were not here today. I emailed you regarding this. Please ignore those emails. It worked. If you have some time, could also please explain the +13 concept in the formula... thanks

Kindly Help please.

Any Help please ?

thanks Hui. Appreciate your help. It worked. I just changed "" to "$0"

Hello, I have a formula IF(ISERROR(IF($H$99>0,G90*$H$99,0)),"",IF($H$99>0,G90*$H$99,0)) which sometimes gives me blank answer. I would like the result to show up as $0 instead of blank THe reason I have other formula which are linked to the result from the above formula Example -...

Hi Narayan, I tried the above formula and I am getting the error message. Could you please have a look at the attached file. http://speedy.sh/kB4ZD/To-remove-DIV.xls Thanks

Hi Narayan, Could you please check the below file and advise what mistake is there in the formula ? Thanks http://speedy.sh/SHc4j/Look-UP-with-three-conditions.xls

THanks a lot for this detailed explaination. I will try this and will let you know. THanks heaps

Hello, FOr the formula (VLOOKUP($I1964,$I$27:$V$498,MATCH(J$1957,$I$27:$V$27,0),0)*1000)/(VLOOKUP($I1964,$I$499:$V$969,MATCH(J$1957,$I$27:$V$27,0),0)) I am getting a #DIV error. I tried...

Very much Understood now. Exactly what I wanted. Hats off to you.