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