function arguments

Good morning, I'm trying to get this function to work, however I'm running into some issues. I'm trying to search multiple model numbers in an array using the SEARCH function, and display output using the IF function. When doing this I can only get SEARCH to find the first value in the array...

I am writing a UDF that essential acts as the function LARGE but utilises a dynamic range. When I run it, it returns Value, but I can't see what the issue is. kRange is a particular Cell on the sheet that contains a range as text e.g. N13:N75; iVal is the cell that contains the nth value that I...

I am going to start with saying that I really have minimal experience with Excel. What I am trying to blindly accomplish at this time is for the "IF's" in 2 cells to have one answer. Basically, if Cell L5 is > 365 AND cell N5 is < 1, then the answer is true, if both are not true, then I need...

Hello Everyone, I'm writing a function to calculate confidence bands for a linear regression of some data. I currently have my function set so that I can choose what range I show my bands over and what % Confidence is used for each fit. As of right now I have successfully made these two...

<tbody> Slabs (Purchases) Discount Applicable on HIGH VALUE PRODUCT 0-99 0% 100-299 1% 300-499 2% 500 and Above 3% </tbody> Conditions: 1. To avail the discount, the purchase bill has to be in the limits mentioned above,a minimum of 100 RO of higher denominations Example below...

Hi, i have huge date contain text/number/combined devises. sample data as below A B A2 21411111 A3 21412232 A4 24600221 A5 24600000 A6 2K221212 A7 2K221213 A8 2D221213 A9 2D221212 A10 71717777 A11 3458 A12 3587 I wanted to get the devises model, result should...

I've made a custom unit conversion function to include units not included with the CONVERT function in excel. The gist of the code is below Option Explicit Function Conv(Amount As Double, Class As String) As Variant Dim factor As Double, A(57,1) As Variant, B(13,1) As Variant, UnitType As...