u/Crunchie04

Updated Ask: Trying to get the Final annual salary to be able an even number after dividing by 52 (weeks). Ok if cents are multiple of 20 (00,.20, .40, .60, .80). Final salary cannot be greater than the Initial Salary.

Ex. 1 Initial Salary is $135,057.17

Divide by 52 = $2,597.2532...

Formula would only use $2,597.20 x 52 (round down to nearest multiple of 0.20 cents) = $135,054.40 Final Salary

Ex. 2 Initial Salary is $184,258.75

Divide by 52 = $3543.4375

Formula would only use $3543.40 x 52 (round down to nearest multiple of 0.20 cents) = $184,256.80 Final Salary

How do write a formula in the "RETURN VALUE" Column that will look at the 1st column "Job" and compare the value with the header in that same row and populate the dollar value.

eg. Job D, compares to the header in that row and returns the value of $30.

https://preview.redd.it/g7464anuekyg1.png?width=419&format=png&auto=webp&s=e8122b40dc2e2e2cf5690c7df878866d5c2728f4

JOB	RETURN VALUE	A	B	C	D
A	$15	$15	$16	$17	$18
D	$30	$20	$18	$16	$30
B	$16	$14	$16	$18	$20
C	$17	$15	$16	$17	$30

I have a column of values under “Total Percent” (A2-A10). In a new column (B2-B10), Trying to return the number at least 5% but no more than 10%. Currently the column A has some negative percents, that I want column B to return at least 5%. And some values say 15% that I want to cap (show) at 10%. Where the value currently has 0%, I want to leave it alone and return 0 or just leave it blank.

For max 10%, I can type in column B the formula =MIN(0.10,[@Total Percent]]) and it returns 10% when column has a value of 25%. How do I amend my formula to capture the other two parameters? Thanks!