Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Project If Function
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 |
#2
|
|||
|
|||
Quote:
=IF(B3=$L$1,$M$1,IF(B3=$L$2,$M$2,(E3*G3)+$H$2)) Is that what you mean? Last edited by Spencer101 : September 24th 12 at 09:47 AM Reason: EDIT: Amended typo in formula. |
#3
|
|||
|
|||
Thanks for your help, I try to use your formula but something is wrong with formula and wont work
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
|
|||
|
|||
Quote:
The Formula You Typed Contains An Error , and wont acept the formula |
#6
|
|||
|
|||
If you can post an example workbook that would be very helpful.
|
#7
|
|||
|
|||
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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))) |
#9
|
|||
|
|||
Quote:
thanks buddy formula works perfectly |
#10
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't find project or library (Mid Function) | Excel Programming | |||
function to count project overlap | Excel Worksheet Functions | |||
call a excel function from a vb project | Excel Programming | |||
Calling a function in another project from within a cell formula | Excel Programming | |||
Excel lost function pointer in BIG project ? | Excel Programming |