70%

Hi, I've been searching for 3 days now for the below requirement but couldn't find an answer. i tried combining multiple VLOOKUP formulas but no luck. i have big data below that is used to forecast when a server will reach memory consumption of 70% B1 to IC1 list of Server names. A2 to A330...

Hi all Excellers, I have a very simple question but may be a bit of a challenge. I made a data bar in the conditional formatting under Styles. The rule type used is "Format all cells based on their values" The resulting bar comes up based on the value of the cell and the minimum number and a...

I'm trying to make a table that will sum a the product of a value and probability based on a criteria value in another column. The table below is an example of what I'm trying to do: <tbody> Criteria Prob 2019 2020 2021 2022 X 100% 41 10 75 150 X 90% 24 24 24 Y 65% 53 160 X 70% 25...

I'm trying to create a spreadsheet that will keep track of my sales reps' advance/draw vs their revenues and commission amounts. For example: I have a sales rep who takes home either the greater of $3,000/mo, or 70% of revenues, provided his draw balance is at $-0-. So, he will always make at...

Please help with a formula I'm trying to work out. I'm trying to return a 'Pass' or 'Fail result based on the following. My criteria is below. A = Loan + Interest B = Loan to Value (%) inc Interest C = Max Loan @ 75% (£750,000) D = Max Loan @ 70% (£1,000,000) E = Max LTV 75% F = Max LTV...

Hi can you say what I did wrong here I want to say if the value in bi is greater than 1384.116 then take bi and minus it from 1384.116 then that result must be multiplied by 70% of the value in c1 then multiply that value by 25% thanks tks Abidh (IFB1>1384.116, then(b1-1384.116)-(.7*c1)*.25)

I need to build logic for below statement: If 2018 Favorability % is greater than 2017 Favorability %, and if 2018 Favorability % is greater than or equal to 70% and if the difference of Favorability percentages 0f 2018-2017 is greater than or equal to 10%, then “positive”, other than that...

Hello, I am preparing Financial statements for many projects using the same pro-forma template on monthly basis (12 columns) and about 150 rows. For some projects all rows will have numbers, for some projects may be 70% of rows are empty. Is it possible to have a macro to hide empty rows that...

Hi, I have a table of data with these columns: Customer Actual Sales Target Sales I want to calculate an overall total sales value at the top of the spreadsheet for customers where Actual Sales/Target sales is above 70%. Do I use sum product, sumif or an array formula? Any help would be...

I want to generate a random number between 1 and X (where X is a dynamic number of varying length/range) in one of three columns (obviously using RANDBETWEEN) but then controlled by a manually-driven weighting factor assigned to each column I can change at any time. So far example, if A1 is...