Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread Learner Excel
here you go.. -- On Tue, Oct 11, 2016 at 6:59 PM, HOTEL PRESIDENT < hotelpresident.raj...@gmail.com> wrote: > pl > reply soon > > *Thanks & Regards* > > *Sohil S. Hudani* > * C/O Hotel President* > *Mo. 9998241341* > > > On Tue, Oct 11, 2016 at 6:37 PM, HOTEL PRESIDENT < >

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread HOTEL PRESIDENT
pl reply soon *Thanks & Regards* *Sohil S. Hudani* * C/O Hotel President* *Mo. 9998241341* On Tue, Oct 11, 2016 at 6:37 PM, HOTEL PRESIDENT < hotelpresident.raj...@gmail.com> wrote: > here the attachment is missing. i need a simple logic for room no 205 and > 201 the rate for pax 1 is

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread HOTEL PRESIDENT
here the attachment is missing. i need a simple logic for room no 205 and 201 the rate for pax 1 is 1500 and the rate for 2 pax is 1700, same way for room no 202,203 and 204 the rate for 1 pax is 1200 and rate for 2 pax is 1400 here i am attching a file in which upon entering the room no and pax

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread HOTEL PRESIDENT
here the attachment is missing. i need a simple logic for room no 205 and 201 the rate for pax 1 is 1500 and the rate for 2 pax is 1700, same way for room no 202,203 and 204 the rate for 1 pax is 1200 and rate for 2 pax is 1400 here i am attching a file in which upon entering the room no and pax

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread Learner Excel
oops attachment missing -- On Tue, Oct 11, 2016 at 5:49 PM, Learner Excel wrote: > Hi Enclosed solution with simple vlookup. > > It would be great if you can share the tariff plan calculation logic so > that we are create this more dynamic > > -- > > On Tue, Oct 11, 2016 at

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread Learner Excel
Hi Enclosed solution with simple vlookup. It would be great if you can share the tariff plan calculation logic so that we are create this more dynamic -- On Tue, Oct 11, 2016 at 1:55 PM, HOTEL PRESIDENT < hotelpresident.raj...@gmail.com> wrote: > pl reply > > *Thanks & Regards* > > *Sohil S.

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread HOTEL PRESIDENT
pl reply *Thanks & Regards* *Sohil S. Hudani* * C/O Hotel President* *Mo. 9998241341* On Tue, Oct 11, 2016 at 1:07 PM, HOTEL PRESIDENT < hotelpresident.raj...@gmail.com> wrote: > Here I've attached a format please check it.. Details given in format > > *Thanks & Regards* > > *Sohil S.

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread HOTEL PRESIDENT
Here I've attached a format please check it.. Details given in format *Thanks & Regards* *Sohil S. Hudani* * C/O Hotel President* *Mo. 9998241341* On Tue, Oct 11, 2016 at 12:53 PM, Deepu Dubey wrote: > Hi, > > What equation you need?? elaborate > > > On Tue, Oct

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread Deepu Dubey
Hi, What equation you need?? elaborate On Tue, Oct 11, 2016 at 12:51 PM, wrote: > > > Need a help in formating an equation for the nested if.. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join

$$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread hotelpresident . rajula
Need a help in formating an equation for the nested if.. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles.