ExcelBanter - Project If Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Project If Function (https://www.excelbanter.com/excel-discussion-misc-queries/447207-project-if-function.html)

sarajmen

Project If Function

1 Attachment(s)

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

Spencer101

Quote:

Originally Posted by sarajmen (Post 1605787)

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?

sarajmen

Quote:

Originally Posted by Spencer101 (Post 1605796)

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

Bruce Bowler

Project If Function

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

sarajmen

Quote:

Originally Posted by Bruce Bowler (Post 1605815)

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

Spencer101

Quote:

Originally Posted by sarajmen (Post 1605853)

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.

sarajmen

Quote:

Originally Posted by Spencer101 (Post 1605860)

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

joeu2004[_2_]

Project If Function

"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))
[....]
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

Quote:

Originally Posted by joeu2004[_2_] (Post 1605923)

thanks buddy formula works perfectly

sarajmen

Quote:

Originally Posted by sarajmen (Post 1605953)

thanks buddy formula works perfectly

Hello,
The following question was referred to the same formula
= IF (B21 = $ L $ 17, $ M $ 17, IF (B21 = $ L $ 18, $ M $ 18, E21 * (G21 * (1 + $ H $ 18))))
Can we define if B21 = any cell in column L and if for example L18 ... M18 or L223 .... Enter M223
thanks

All times are GMT +1. The time now is 06:52 PM.