Need Excel Formula

[Giriraj Desai]

Hi,

Can you please help to get the formula where I have more than 1000 lines and it needs to be check on daily basis. I have attached the file for you reference.

Many thanks for your help in advance.

Regards
Giriraj

 

[NARAYANK991]

Hi ,

I am not clear on what you want to do.

Can you upload the workbook which has all of your data , so that it becomes clear ?

Narayan

 

[rahulshewale1]

hii,

Please see formula i hope it will work .
=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C",IF(G5>1000,"D"))))
thanks
Rahul shewale

 

[bosco_yip]

Another opion

=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C","D")))

or,

=LOOKUP(G5,100*{0,1,5,10},{"A","B","C","D"})

Regards

 

[Giriraj Desai]

Hi,

Can you please help to get the formula where I have more than 1000 lines and it needs to be check on daily basis. I have attached the file for you reference.

Many thanks for your help in advance.

Regards
Giriraj

Hi ,

I am not clear on what you want to do.

Can you upload the workbook which has all of your data , so that it becomes clear ?

Narayan

Hi Narayana,

The below formula is working

=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C",IF(G5>1000,"D"))))

even this too is working

=LOOKUP(G5,100*{0,1,5,10},{"A","B","C","D"})

Many thanks to all who has given the formula

however will brief you more

this is to find out the approver name from the list we have many approvers on the list of data where we need to assign them correctly based on the amount to get it approved before processing ,this is what i have explained in the workbook. let me know if it not clear.

 

[bosco_yip]

.....
The below formula is working
=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C",IF(G5>1000,"D"))))......

=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C",IF(G5>1000,"D"))))

But, if G5 =1000, the above formula will return "FALSE".

To fix it by adding "=" as in :

=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C",IF(G5>=1000,"D"))))

Or, by this shorter :

=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C","D")))

And, here's some possible :

=MID("ABCD",MATCH(G5,100*{0,1,5,10}),1)

=TEXT(0&G5-100,"[>=900]\D;[>=400]C;\B;A")

Regards

 

[Giriraj Desai]

=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C",IF(G5>1000,"D"))))

But, if G5 =1000, the above formula will return "FALSE".

To fix it by adding "=" as in :

=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C",IF(G5>=1000,"D"))))

Or, by this shorter :

=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C","D")))

And, here's some possible :

=MID("ABCD",MATCH(G5,100*{0,1,5,10}),1)

=TEXT(0&G5-100,"[>=900]\D;[>=400]C;\B;A")

Regards

=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C",IF(G5>1000,"D"))))

But, if G5 =1000, the above formula will return "FALSE".

To fix it by adding "=" as in :

=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C",IF(G5>=1000,"D"))))

Or, by this shorter :

=IF(G5<100,"A",IF(G5<500,"B",IF(G5<1000,"C","D")))

And, here's some possible :

=MID("ABCD",MATCH(G5,100*{0,1,5,10}),1)

=TEXT(0&G5-100,"[>=900]\D;[>=400]C;\B;A")

Regards

 

[Giriraj Desai]

Many thanks Bosco...

However I have another criteria in that, I have list and there are many company codes in that and the approval matrix will be the same , is it possible that formula will look also the column B ,I have attached the new file .

 

[p45cal]

See attached.

 

[Giriraj Desai]

See attached.

Hi p45cal,

Many thanks this worked out for me .