Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If funcion on big formula
I have the following formula: Schematic: (A+C+E) + 0,57(B+D) - 3,14d Excel: =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3 The original formula contains the following note: If B or D 400 add 2d some other formulas use ≥ sign instead of I know what 2d will be (2*Sheet1!F3) Is it possible to incorporate this "IF" into the function? :nuts Thanks -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98081 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If funcion on big formula
Hi,
=if(or(B400,D400),Sheet1!M3+Sheet1!O3+Sheet1!Q3) +0.57*(Sheet1!N3+Sheet1!P3)-2*Sheet1!F3,Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(S heet1!N3+Sheet1!P3)-3.14*Sheet1!F3) "willemeulen" wrote: I have the following formula: Schematic: (A+C+E) + 0,57(B+D) - 3,14d Excel: =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3 The original formula contains the following note: If B or D 400 add 2d some other formulas use ‰¥ sign instead of I know what 2d will be (2*Sheet1!F3) Is it possible to incorporate this "IF" into the function? :nuts Thanks -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98081 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If funcion on big formula
"willemeulen" wrote:
(A+C+E) + 0,57(B+D) - 3,14d [....] =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3 The original formula contains the following note: If B or D 400 add 2d =Sheet1!M3+Sheet1!O3+Sheet1!Q3 + 0.57*(Sheet1!N3+Sheet1!P3) - 3.14*Sheet1!F3 + 2*Sheet1!F3*or(Sheet1!N3400,Sheet1!P3400) ----- original message ----- "willemeulen" wrote in message ... I have the following formula: Schematic: (A+C+E) + 0,57(B+D) - 3,14d Excel: =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3 The original formula contains the following note: If B or D 400 add 2d some other formulas use ≥ sign instead of I know what 2d will be (2*Sheet1!F3) Is it possible to incorporate this "IF" into the function? :nuts Thanks -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98081 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If funcion on big formula
willemeulen wrote:
I have the following formula: Schematic: (A+C+E) + 0,57(B+D) - 3,14d Excel: =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3 The original formula contains the following note: If B or D 400 add 2d some other formulas use ≥ sign instead of I know what 2d will be (2*Sheet1!F3) Is it possible to incorporate this "IF" into the function? :nuts Thanks =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3+IF(MAX(Sheet1!N3,Sheet1!P3)400),2* Sheet1!F3,0) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If funcion on big formula
Glenn wrote:
willemeulen wrote: I have the following formula: Schematic: (A+C+E) + 0,57(B+D) - 3,14d Excel: =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3 The original formula contains the following note: If B or D 400 add 2d some other formulas use ≥ sign instead of I know what 2d will be (2*Sheet1!F3) Is it possible to incorporate this "IF" into the function? :nuts Thanks =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3+IF(MAX(Sheet1!N3,Sheet1!P3)400),2* Sheet1!F3,0) Sorry, too many ")" in that formula...corrected below: =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)- 3.14*Sheet1!F3+IF(MAX(Sheet1!N3,Sheet1!P3)400,2*S heet1!F3,0) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If funcion on big formula
Glenn;350598 Wrote: Glenn wrote: willemeulen wrote: I have the following formula: Schematic: (A+C+E) + 0,57(B+D) - 3,14d Excel: =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3 The original formula contains the following note: If B or D 400 add 2d some other formulas use ≥ sign instead of I know what 2d will be (2*Sheet1!F3) Is it possible to incorporate this "IF" into the function? :nuts Thanks =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3+IF(MAX(Sheet1!N3,Sheet1!P3)400),2* Sheet1!F3,0) Sorry, too many ")" in that formula...corrected below: =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)- 3.14*Sheet1!F3+IF(MAX(Sheet1!N3,Sheet1!P3)400,2*S heet1!F3,0) When I add the last bit to my formula it does not seem the affect the outcome at all, I mean when I increase B (sheet1!N3) or D (sheet1!P3) from 400 to 401 nothing happens (minimal increase in outcome). Is the MAX application correct, I'm not shore but only when B or D is bigger than 400 2d (2*d) needs to be added to the already calculated figure. Does OR need to be in the function? I will try this solution on some of the other formula's as well where the IF is only applicable for one value. -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98081 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If funcion on big formula
willemeulen wrote:
Glenn;350598 Wrote: Glenn wrote: willemeulen wrote: I have the following formula: Schematic: (A+C+E) + 0,57(B+D) - 3,14d Excel: =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3 The original formula contains the following note: If B or D 400 add 2d some other formulas use ≥ sign instead of I know what 2d will be (2*Sheet1!F3) Is it possible to incorporate this "IF" into the function? :nuts Thanks =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)-3.14*Sheet1!F3+IF(MAX(Sheet1!N3,Sheet1!P3)400),2* Sheet1!F3,0) Sorry, too many ")" in that formula...corrected below: =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)- 3.14*Sheet1!F3+IF(MAX(Sheet1!N3,Sheet1!P3)400,2*S heet1!F3,0) When I add the last bit to my formula it does not seem the affect the outcome at all, I mean when I increase B (sheet1!N3) or D (sheet1!P3) from 400 to 401 nothing happens (minimal increase in outcome). Is the MAX application correct, I'm not shore but only when B or D is bigger than 400 2d (2*d) needs to be added to the already calculated figure. Does OR need to be in the function? I will try this solution on some of the other formula's as well where the IF is only applicable for one value. The logic of the MAX() function should work fine. It just compares the largest of the two values to 400. The smallest of the two values doesn't matter according to your request. I used MAX() to save a couple of keystrokes over the alternative using OR(): =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+S heet1!P3)- 3.14*Sheet1!F3+IF(OR(Sheet1!N3400,Sheet1!P3400), 2*Sheet1!F3,0) As for your apparent lack of results, I would need to know the contents every cell referenced in the formula, the results you expect and the results you are getting to figure out what the problem may be. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Donde hay que poner la funcion DESREF para crear un ragon dinamico ? | Excel Worksheet Functions | |||
Is there any funcion like a @maxif or @minif? | Excel Worksheet Functions | |||
funcion de distribucion empirica | Excel Worksheet Functions | |||
Quiero usar la funcion buscarh buscando un valor distinto de 0 | Excel Worksheet Functions | |||
how do see add-in a funcion belongs to | Excel Discussion (Misc queries) |