extra

Hello, I am trying to add an extra condition into my formula but I can’t make it work. So far, what I have is this: =IF(C28=B11,1, IF(C28=B11-1,1, IF(C28=B11-2,1, IF(C28=B11-3,1, IF(C28=B11-4,1, IF(C28=B11-5,1,0)))))) Which is basically saying, if C28 is equal to or less than B11 by up...

Hi I'm having hard time figuring out how to auto calculate the following in excel <tbody> From To Total 12% 50% 23:00 07:00 8 2 6 15:00 23:00 8 8 0 </tbody> So this is a work timetable where we get 12% extra if it's between 06:00 and 24:00 We get 50% extra for the time between 24:00 and...

I designed a amortization table (see link below). The top portion provides a summary of the loan, where the green color cells are hard coded input cells (except cell B8, because I do not know how to calculate the last year of a loan when a fixed extra amount is paid monthly). Once the input...

Hi, I have the following formula; =IF(G36="","",AVERAGEIF(INDEX('Heifers-Steers-Day'!$U$36:$NU$1214,0,MATCH($G36,'Heifers-Steers-Day'!$U$32:$NU$32,0)),">0")) I need to add 2 extra conditions to the ">0" condition. These are; 'Heifers-Steers-Day'!$G$36:$G$1214,">="&$V36...

So I basically have a large list of account numbers in Excel that I can use to lookup each account on EXTRA! Attachmate. I want to write VBA either through Excel or EXTRA! that can open up EXTRA, enter in prewritten information, copy in the account number, read a line in the account, and then...

Hello Guys, I am running the below Macro for quick password resets for other Attachmate users. I would like to replace the PasswordBox with a TextBox so I can see what I am tiping in. At the moment, because of the PasswordBox field I can only see ****** instead of the User ID. I am new at this...

Hi everyone, with code like this: Cells.Select Selection.Sort Key1:=Range("G2"), Order1:=xlAscending, Key2:=Range("M2") _ , Order2:=xlAscending, Key3:=Range("H2"), Order3:=xlAscending, Header:= _ xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _...