How I can use conditional formula in one cell

[Mohammad Younous]

5000 < = 65%, Minimum 2800

5001 – 10800 = 60%, Minimum 3300

10801 – 21600 = 55%, Minimum 6500

21601> = 50%, Minimum 11900

How I can use conditional formula in one cell.

 

[Syedali]

5000 < = 65%, Minimum 2800

5001 – 10800 = 60%, Minimum 3300

10801 – 21600 = 55%, Minimum 6500

21601> = 50%, Minimum 11900

How I can use conditional formula in one cell.

You specified the ranges then what is the meaning of Minimum amount you mentioned. Kindly clarfiy

 

[Mohammad Younous]

if result less then minimum Amount then minimum amount must be here.

 

[bobhc]

Use Lookup

 

[Mohammad Younous]

how I use Lookup @ bobhc

 

[Khalid NGO]

how I use Lookup @ bobhc

Hi Younous,
As Bob said use lookup, suppose your lookup value is in A2:
=LOOKUP(A2,{1,5001,10801,21601},{"Minimum 2800","Minimum 3300","Minimum 6500","Minimum 11900"})

This is hard coded (not preferred), you can avoid hardcoding by giving it a range.

Regards,

 

[Syedali]

if result less then minimum Amount then minimum amount must be here.

Below my question. Sorry am trying to understand your exact requirement don't mistake me.

 

[Mohammad Younous]

Use Lookup

Please check the attached file.

 

[Mohammad Younous]

Below my question. Sorry am trying to understand your exact requirement don't mistake me.
View attachment 17839

 

[Syedali]

Hi PFA,

 

[Mohammad Younous]

Hi PFA,

Thanks a lot.

 

[Syedali]

Thanks a lot.

Most Welcome.