100

Dear All, I'm struggling with Sumproduct formula to calculate bonus based on percentage budget achieved (see below). My desired amount Column U and the formula I'm trying to implement in Column T. If % Budget achieved is 100% then you expect 7.5% Bonus, $7,500 (100,000*7.5%). If you achieved...

Column A, cells A1, A2 etc have values in it. i.e. 525000 675000 etc. In cell B1, B2 etc I need to know how to get 7% of the first 100,000 and 2.5% of the remaining amount I.E 525,000, 7% of 100,000 plus 2.5% of 425,000 675,000, 7% of the first 100,000 plus 2.5% of 575,000 I can do it in two...

Hi Atry adapt a code, but din't work. Before Nº da NFe Série Data Emissão BASE ICMS ST CST Código do Produto 2805151 3 43643 110,78 210 101173 2805153 3 43643 100,44 510 100092 2805155 3 43643 1028,35 210 106447 2805157 3 43643 50,67 570 402850 2805159 3 43643 100,44 510 100092 2805161 3 43643...

Hello, I have GL data that basically looks like this A1:GL Acct # B1: Name C1: Total D1: Department 1 E1: Department 2 F1: Department 3 A2: 65000 B2: Wages C2: 1,000,000 D2: 500,000 E2: 250,000 F2: 250000 A3: 79000 B3: Travel C3...

Would it be possible to randomly distribute a sum (say 100,000) over 10 distinct cells? "0" is an acceptable result for any given cell, and in fact 9 out of 10 cells could feature 0 with the final cell containing the full 100,000. I am just trying to randomly distribute the sum (on a...

I have a .bmp image I'd like on my worksheet via code, but not having much success. pname= "D:\logo4.bmp" With Worksheets("Test") .shapes.addpicture(pname,False, True,100, 10, -1, -1) End With It won't compile, tells me "Expected = " Thanks for any help

I already have the formula: =MAX(100,ROUNDUP(AB946/25,-1)) + IF(AB946>=5200,100,0) - thanks to Joe4 But, only if AB946 is greater or equal to 5200, I wish also to add a condition to the above formula: to "replace" AB946 with AB946-200, so that IF AB946 >= 5200, to make the calculation...

Hello Community, I've been stumped with a question for a bit while using a SUMPRODUCT. Below I have a fairly simple of example of what I want to accomplish. If the stock price ($20) is greater than the strike price, I want to take the difference and multiply it by the units. If I have a stock...

Hello Add New member here and trying to work with excel. I am sorry if I make mistake the way, I am really new to this. What I am trying to do is: Inter link two order books ( as in an exchange) of two currency pairs; using price and volume. I have tried several times to work out a formula...

Hi How can I fill a range, lets say A1:D30 with randbetween(1,100) in VBA? Thank you very much.

Hi! So here is the problem. We get a PDF report, and since it is not that well made, when we extract it into excel All the different columns get put into column one together. We only need a few lines from there that I managed to offset (so some cells in column D are empty) and from these lines...

Any help here would be appreciated. We have moved to the online subscription of Excel and my previous EVALUATE function doesn't seem to exist. I do not have any background in VBA, so I'm unsure of the possible solutions to my problem which appear in searches. I have some very large sheet that...

Hi All! I'm looking to return a different value based on whether cell C35 is between multiple ranges... i.e.: ($0-$25,000 = $500); ($25,001-$50,000 = $1000); ($50,001 -100,000 = $1,500); (100,001+ = 2,000) I've tried (and failed) at various nest IFs and lookups... any help is sincerely...

Team, How would i rewrite this formula so the middle part is greater 6 and less then 18. I bolded it. =IF(ISERROR(B9+1),100,(IF(B9<=6,(6-B9)/6*50+100,IF(B9<=18,IF((18-B9)/12*50+50,B9>18,0)))))

Hi All I am trying to use the TRIM function in VBA but am struggling! The code which works in excel is: =TRIM(RIGHT(SUBSTITUTE(N2,"-",REPT(" ",100)),100)) when I try to use the same in VBA, I get a compile error: expected end of statement I assume that this is because of the " within the...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would like to create a vba code so that to prepare the percentages in col. C, E, G, I, K, based on categories descriptions criteria, as my below P & L...

HI, I NEED TO FIND VALUES AND CONCAT IT. BELOW IS THE DETAILS DATA'S a 1 b 2 c 3 d 4 a 100 b 101 c 102 d 103 NEED FORMULA AS BELOW A = 1,100 B= 2,101 C=3,102 THANK YOU & REGARDS PARTHI