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 <
> 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 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 the value should be automatically
>> generated in tariff.
>>
>> *Thanks & Regards*
>>
>> *Sohil S. Hudani*
>> * C/O Hotel President*
>> *Mo. 9998241341*
>>
>>
>> On Tue, Oct 11, 2016 at 6:36 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 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 the value should be
>>> automatically generated in tariff.
>>>
>>> *Thanks & Regards*
>>>
>>> *Sohil S. Hudani*
>>> * C/O Hotel President*
>>> *Mo. 9998241341*
>>>
>>>
>>> On Tue, Oct 11, 2016 at 5:49 PM, Learner Excel 
>>> wrote:
>>>
 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 1:55 PM, HOTEL PRESIDENT <
> hotelpresident.raj...@gmail.com> wrote:
>
>> 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. 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 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 official Facebook page of this 
> forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
> Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any
> security measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com
> .
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

 --
 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. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any
 security measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posti

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 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 the value should be automatically
> generated in tariff.
>
> *Thanks & Regards*
>
> *Sohil S. Hudani*
> * C/O Hotel President*
> *Mo. 9998241341*
>
>
> On Tue, Oct 11, 2016 at 6:36 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 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 the value should be automatically
>> generated in tariff.
>>
>> *Thanks & Regards*
>>
>> *Sohil S. Hudani*
>> * C/O Hotel President*
>> *Mo. 9998241341*
>>
>>
>> On Tue, Oct 11, 2016 at 5:49 PM, Learner Excel  wrote:
>>
>>> 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 1:55 PM, HOTEL PRESIDENT <
 hotelpresident.raj...@gmail.com> wrote:

> 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. 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 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 official Facebook page of this 
 forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any
 security measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it,
 send an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at https://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>> --
>>> 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. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>> and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribe

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 the value should be automatically
generated in tariff.

*Thanks & Regards*

*Sohil S. Hudani*
* C/O Hotel President*
*Mo. 9998241341*


On Tue, Oct 11, 2016 at 5:49 PM, Learner Excel  wrote:

> 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 1:55 PM, HOTEL PRESIDENT <
>> hotelpresident.raj...@gmail.com> wrote:
>>
>>> 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. 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 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 official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/to
> pic/excel-macros/Q2F8YLfdGd0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>


>>> --
>>> 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. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the threa

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 the value should be automatically
generated in tariff.

*Thanks & Regards*

*Sohil S. Hudani*
* C/O Hotel President*
*Mo. 9998241341*


On Tue, Oct 11, 2016 at 6:36 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 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 the value should be automatically
> generated in tariff.
>
> *Thanks & Regards*
>
> *Sohil S. Hudani*
> * C/O Hotel President*
> *Mo. 9998241341*
>
>
> On Tue, Oct 11, 2016 at 5:49 PM, Learner Excel  wrote:
>
>> 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 1:55 PM, HOTEL PRESIDENT <
>>> hotelpresident.raj...@gmail.com> wrote:
>>>
 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. 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 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 official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>> and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> 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. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to a topic in
>> the Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/excel-macros/Q2F8YLfdGd0/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, se

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 1:55 PM, HOTEL PRESIDENT <
> hotelpresident.raj...@gmail.com> wrote:
>
>> 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. 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 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 official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

 --
 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. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to a topic in the
 Google Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this topic, visit https://groups.google.com/d/to
 pic/excel-macros/Q2F8YLfdGd0/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at https://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>
>> --
>> 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. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@g

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. 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. 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 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 official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at https://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>> --
>>> 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. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>>> pic/excel-macros/Q2F8YLfdGd0/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
> --
> 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. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
A

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. 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 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 official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> 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. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/excel-macros/Q2F8YLfdGd0/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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 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 official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/excel-macros/Q2F8YLfdGd0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


If.xlsx
Description: MS-Excel 2007 spreadsheet


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 official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.