Project If Function

S

sarajmen

Hi there,

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

thank

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

Spencer101

sarajmen;1605787 said:
Hi there,

please I need a help. SELLING PRICE (H3) is equal to = IF THE (B3 = L
ENTER (M1), or if B3 = (L2) ENTER (M2), IF (B3) does not contain (L1 o
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

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
S

sarajmen

Spencer101;1605796 said:
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 wron
with formula and wont wor

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
S

sarajmen

Bruce said:
On Mon, 24 Sep 2012 19:48:04 +0000, sarajmen wrote:
-

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

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

Do you mean it gives the wrong values? If so, please provide the value

that are inputs (B3, L1, M1, L2, M2, E3, G3 and H2) and the expected an

actual outputs (H3).

Bruce

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

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
S

Spencer101

sarajmen;1605853 said:
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

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
S

sarajmen

Spencer101;1605860 said:
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 i
not allowed, I did upload the Word file. Thanks for your help and m
email is thanks (e-mail address removed)

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
J

joeu2004

sarajmen said:
[....]
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)))
 
S

sarajmen

'joeu2004[_2_ said:
;1605923']"sarajmen said:
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 perfectl

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top