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