Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
microsoft.public.excel.misc
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
Project If Function
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   9 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
sarajmen  
View profile  
 More options Sep 23 2012, 6:47 pm
Newsgroups: microsoft.public.excel.misc
From: sarajmen <mulic_ad...@hotmail.com>
Date: Sun, 23 Sep 2012 22:47:25 +0000
Local: Sun, Sep 23 2012 6:47 pm
Subject: Project If Function
Print | Individual message | Show original | Report this message | Find messages by this author

Hi there,

please I need a help.  SELLING PRICE (H3) is equal to = IF THE (B3 = L1
ENTER (M1), or if B3 = (L2) ENTER (M2), IF (B3) does not contain (L1 or
L2) THEN (E3) multiplied by (G3) PLUS H2)

thanks

+-------------------------------------------------------------------+
|Filename: TASK.pdf                                                 |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=595|
+-------------------------------------------------------------------+

--
sarajmen


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Spencer101  
View profile  
 More options Sep 24 2012, 4:46 am
Newsgroups: microsoft.public.excel.misc
From: Spencer101 <spencer.davisREMOVETHIS...@btinternet.com>
Date: Mon, 24 Sep 2012 08:46:35 +0000
Local: Mon, Sep 24 2012 4:46 am
Subject: Re: Project If Function
Print | Individual message | Show original | Report this message | Find messages by this author

sarajmen;1605787 Wrote:

> Hi there,

> please I need a help.  SELLING PRICE (H3) is equal to = IF THE (B3 = L1
> ENTER (M1), or if B3 = (L2) ENTER (M2), IF (B3) does not contain (L1 or
> L2) THEN (E3) multiplied by (G3) PLUS H2)

> thanks

Try this in cell H3 and copy down.

=IF(B3=$L$1,$M$1,IF(B3=$L$2,$M$2,(E3*G3)+$H$2))

Is that what you mean?

+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

--
Spencer101


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
sarajmen  
View profile  
 More options Sep 24 2012, 3:39 pm
Newsgroups: microsoft.public.excel.misc
From: sarajmen <mulic_ad...@hotmail.com>
Date: Mon, 24 Sep 2012 19:48:04 +0000
Local: Mon, Sep 24 2012 3:48 pm
Subject: Re: Project If Function
Print | Individual message | Show original | Report this message | Find messages by this author

Spencer101;1605796 Wrote:

> Try this in cell H3 and copy down.

> =IF(B3=$L$1,$M$1,IF(B3=$L$2,$M$2,(E3*G3)+$H$2))

> Is that what you mean?

Thanks for your help, I try to use your formula but something is wrong
with formula and wont work

+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

--
sarajmen


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Bruce Bowler  
View profile  
 More options Sep 24 2012, 3:49 pm
Newsgroups: microsoft.public.excel.misc
From: Bruce Bowler <bbow...@bigelow.org>
Date: 24 Sep 2012 19:49:11 GMT
Local: Mon, Sep 24 2012 3:49 pm
Subject: Re: Project If Function
Print | Individual message | Show original | Report this message | Find messages by this author

On Mon, 24 Sep 2012 19:48:04 +0000, sarajmen wrote:
> Spencer101;1605796 Wrote:
>> Try this in cell H3 and copy down.

>> =IF(B3=$L$1,$M$1,IF(B3=$L$2,$M$2,(E3*G3)+$H$2))

>> Is that what you mean?

> Thanks for your help, I try to use your formula but something is wrong
> with formula and wont work

> +-------------------------------------------------------------------+
> +-------------------------------------------------------------------+

Can you define what you mean by "won't work"?

Do you mean it gives the wrong values?  If so, please provide the values
that are inputs (B3, L1, M1, L2, M2, E3, G3 and H2) and the expected and
actual outputs (H3).

Bruce


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
sarajmen  
View profile  
 More options Sep 25 2012, 4:10 pm
Newsgroups: microsoft.public.excel.misc
From: sarajmen <mulic_ad...@hotmail.com>
Date: Tue, 25 Sep 2012 20:10:02 +0000
Local: Tues, Sep 25 2012 4:10 pm
Subject: Re: Project If Function
Print | Individual message | Show original | Report this message | Find messages by this author

Bruce Bowler;1605815 Wrote:

I get a msg
The Formula You Typed Contains An Error , and wont acept the formula

+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

--
sarajmen


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Spencer101  
View profile  
 More options Sep 26 2012, 4:15 am
Newsgroups: microsoft.public.excel.misc
From: Spencer101 <spencer.davisREMOVETHIS...@btinternet.com>
Date: Wed, 26 Sep 2012 08:15:18 +0000
Local: Wed, Sep 26 2012 4:15 am
Subject: Re: Project If Function
Print | Individual message | Show original | Report this message | Find messages by this author

sarajmen;1605853 Wrote:

> I get a msg
> The Formula You Typed Contains An Error , and wont acept the formula

If you can post an example workbook that would be very helpful.

+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

--
Spencer101


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
sarajmen  
View profile  
 More options Sep 26 2012, 6:11 pm
Newsgroups: microsoft.public.excel.misc
From: sarajmen <mulic_ad...@hotmail.com>
Date: Wed, 26 Sep 2012 22:11:49 +0000
Local: Wed, Sep 26 2012 6:11 pm
Subject: Re: Project If Function
Print | Individual message | Show original | Report this message | Find messages by this author

Spencer101;1605860 Wrote:

> If you can post an example workbook that would be very helpful.

Hello friend I am unable to upload the excel file because the page is
not allowed, I did upload the Word file. Thanks for your help and my
email is thanks mulic_ad...@hotmail.com

+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

--
sarajmen


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
joeu2004  
View profile  
 More options Sep 27 2012, 5:27 am
Newsgroups: microsoft.public.excel.misc
From: "joeu2004" <joeu2...@foo.bar>
Date: Thu, 27 Sep 2012 02:26:57 -0700
Local: Thurs, Sep 27 2012 5:26 am
Subject: Re: Project If Function
Print | Individual message | Show original | Report this message | Find messages by this author

"sarajmen" <mulic_ad...@hotmail.com> wrote:
>> > Spencer101;1605796 Wrote:-
>> >> Try this in cell H3 and copy down.
>> >> =IF(B3=$L$1,$M$1,IF(B3=$L$2,$M$2,(E3*G3)+$H$2))
[....]
> I get a msg
> The Formula You Typed Contains An Error

Perhaps you should use semicolons instead of commas for separators.  Try:

=IF(B3=$L$1;$M$1;IF(B3=$L$2;$M$2;E3*G3+$H$2))

And since your English description is ambiguous, try the following
alternative if the formula above gives the wrong numerical result:

=IF(B3=$L$1;$M$1;IF(B3=$L$2;$M$2;E3*(G3+$H$2)))


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
sarajmen  
View profile  
 More options Sep 27 2012, 5:00 pm
Newsgroups: microsoft.public.excel.misc
From: sarajmen <mulic_ad...@hotmail.com>
Date: Thu, 27 Sep 2012 21:00:21 +0000
Local: Thurs, Sep 27 2012 5:00 pm
Subject: Re: Project If Function
Print | Individual message | Show original | Report this message | Find messages by this author

'joeu2004[_2_ Wrote:

thanks buddy formula works perfectly

+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

--
sarajmen


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2013 Google