Help with IFS statement

[Sirod]

Hello,
I'm working on a commission table and need help with an IFS statement. Below is a sample table.

In column F I want to add a calculation:

• For full-time employees, if the amount paid is less than the salary rate, the salary rate should be listed, otherwise the amount paid should be listed.
• For part-time employees, if the amount paid is less than the salary rate, I want to list $50,000, otherwise the amount paid should be listed.

I started with =(D4<E4, E4,D4), but I'm struggled with how to revise the formula to add the full-time/part-time condition, as well as to pull in a separate amount for part-time if the payment is less than the salary rate.

Thanks.

 

[Fluff]

How about

=IF(D2<E2,IF(A2="full-time",E2,50000),D2)

 

[Sufiyan97]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Skybluekid]

Assuming that you have 365

Book1.xlsm
	A	B	C	D	E	F	G
1	Full—
2	time/Part-	ID	Name	Paid	Salary Rate	Column
3	Full-time	12345	Sales Rep A	$86,854.41	$81,831.29	$86,854.41
4	Full-time	12346	Sales Rep B	$64,955.14	$70,795.22	$70,795.22
5	Full-time	12347	Sales Rep C	$25,946.12	$76,958.98	$76,958.98
6	Full-time	12348	Sales Rep D	$39,190.62	$82,516.15	$82,516.15
7	Part-time	12349	Sales Rep E	$105,383.32	$100,518_25	$105,383.32
8	Part-time	12350	sales Rep F	$74,130.93	$100,518_25	$74,130.93
9	Part-time	12351	Sales Rep G	$46,192 65	$92,906.49	$50,000
10	Part-time	12352	Sales Rep h	$91,513.49	$99,070.25	$50,000
11
Sheet5

Cell Formulas
Range	Formula
F3:F10	F3	=IFS(AND(A3="Full-time",D3<E3),E3,AND(A3="Full-time",D3>E3),D3,AND(A3="Part-time",D3<E3),"$50,000",TRUE,D3)