Divide Function with conditions

[srinath tantri]

Hello,

I am looking preparing a tool which helps in getting value based upon certain clauses provided below :

If X= 500$
Y = 1 (Frequency for time period in months).
Z=500$/2 and Z > 200$ then Z should be Maximum limit of "200$" per 1 month.

In other case,

If X=500$
Y= 2
Z= 500$/2 and Z>400$ then Z should be Maximum limit of "400$" per 2 months.

 

[srinath tantri]

Re: Divide Function with condtions!!

Hello,

I am looking for assistance in preparing a tool which helps in getting values based upon certain clauses provided below :

If X= 500$
Y = 1 (Frequency for time period in months).
Z=500$/2 and Z > 200$ then Z should be Maximum limit of "200$" per 1 month.

In other case,

If X=500$
Y= 2
Z= 500$/2 and Z>400$ then Z should be Maximum limit of "400$" per 2 months.

Appreciate your help on this in advance!

Have a great day ahead!

 

[mystie]

Re: Divide Function with condtions!!

Assuming X is in A1, Y in B1, Z in C1 and message to be displayed in D1.

In C1, enter

=A1/2

in D1, enter

= IF(AND(B1=1, C1>200),"Maximum limit of 200$ per 1 month",  IF(AND(B1=2, C1>400),"Maximum limit of 400$ per 2 months", ""))

 

[srinath tantri]

Re: Divide Function with condtions!!

Hello Mystie,

Thanks for all your help, the code you have provided has assisted me initially starting up and following the same for replicating it for other conditions as well.

I really appreciate your prompt response on this.

Will post few more condtions and hope you help me in solving them too.!

Have a great day ahead!

 

[mystie]

Re: Divide Function with condtions!!

Happy to have been able to help Srinath.