hi
you cont need such formula.. use this
formula =A1-MOD(A1,10)-A1-MOD(A1,10)+10
It is modeless whatever be the range yo have your answer!!
Cheers!!
On Mon, Jul 28, 2014 at 12:19 PM, Prafull Jadhav prafulltjad...@gmail.com
wrote:
Dear Vaibhav Sir,
Your formula is very good,Appreciate!
Can
Awesome!.Vaibhav Sir.
Thanks a Lot!
Regards,
Prafull Jadhav
9920553518
On 28 July 2014 12:28, Vaibhav Joshi v...@vabs.in wrote:
hi
you cont need such formula.. use this
formula =A1-MOD(A1,10)-A1-MOD(A1,10)+10
It is modeless whatever be the range yo have your answer!!
Cheers!!
another way
=CHOOSE(MATCH(A1,{red,sta,ida,pco,pid,pde},0),us2,ru2,cu2,us3,ru3,cu3)
On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain nur2...@gmail.com wrote:
Dear all , how to merge following six formula into single formula.
small formula is required . Thanks
IF(A1=red,us2,)
IF(A1=sta,ru2,)
you can also use:
=VLOOKUP(A1,{red,us2;sta,ru2;ida,cu2;pco,us3;pid,ru3;pde,cu3},2,0)
Cheers!!
On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain nur2...@gmail.com wrote:
Dear all , how to merge following six formula into single formula.
small formula is required . Thanks
IF(A1=red,us2,)
Dear Joshi da, it works perfectly thanks for your different idea
except IF formula..
On Sat, Jul 26, 2014 at 1:51 PM, Vaibhav Joshi v...@vabs.in wrote:
you can also use:
=VLOOKUP(A1,{red,us2;sta,ru2;ida,cu2;pco,us3;pid,ru3;pde,cu3},2,0)
Cheers!!
On Sat, Jul 26, 2014 at 9:22 AM, Nur
Hi Pramod da,
It works perfectly , thanks for your supports
On Sat, Jul 26, 2014 at 9:58 AM, Pramod Singh pramod...@gmail.com wrote:
H Nur,
Your Formula will be
=IF(A1=Red,us2,IF(A1=Sta,ru2,IF(A1=Ida,Cu2,IF(A1=Pco,Us3,IF(A1=Pde,Cu3,)
Regards
Pramod
On Sat, Jul 26, 2014 at
Your Welcome..
On Sat, Jul 26, 2014 at 9:48 AM, Nur Hossain nur2...@gmail.com wrote:
Hi Pramod da,
It works perfectly , thanks for your supports
On Sat, Jul 26, 2014 at 9:58 AM, Pramod Singh pramod...@gmail.com wrote:
H Nur,
Your Formula will be