Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Project If Function

60 views
Skip to first unread message

sarajmen

unread,
Sep 23, 2012, 6:47:25 PM9/23/12
to

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

Spencer101

unread,
Sep 24, 2012, 4:46:35 AM9/24/12
to

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

sarajmen

unread,
Sep 24, 2012, 3:48:04 PM9/24/12
to

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

Bruce Bowler

unread,
Sep 24, 2012, 3:49:11 PM9/24/12
to
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

sarajmen

unread,
Sep 25, 2012, 4:10:02 PM9/25/12
to

Bruce Bowler;1605815 Wrote:
> 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

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


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



--
sarajmen

Spencer101

unread,
Sep 26, 2012, 4:15:18 AM9/26/12
to

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

sarajmen

unread,
Sep 26, 2012, 6:11:49 PM9/26/12
to

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...@hotmail.com


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



--
sarajmen

joeu2004

unread,
Sep 27, 2012, 5:26:57 AM9/27/12
to
"sarajmen" <mulic...@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)))

sarajmen

unread,
Sep 27, 2012, 5:00:21 PM9/27/12
to

'joeu2004[_2_ Wrote:
> ;1605923']"sarajmen" <mulic...@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)))


thanks buddy formula works perfectly


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



--
sarajmen
0 new messages