IF programming question

8 replies
3926 views
Translate All

Hi all,

For the attached sheet, I am trying to calculate the mid-point of each layer using an if statement. The values are entered using an Excel table. For the first layer, the mid-point is simply H0/2 (so 0.9 m). For the second layer, the mid-point is the previous mid-point, plus the average of the previous and current points (so, 0.9 m + (1.8+1.6)/2 = 2.6 m). For some reason however, the simple IF code I am trying to use doesn't seem to work. I am not very familiar with programming in Mathcad, so any help would be appreciated.

Thanks!

-Fikret

1_Mid-point.zip

Programming

L

LucMeekesAnswer

23-Emerald IV

I guess this is what you're after.

Recreate the little program in your Prime, and it should work.

Success!
Luc

F

Fred_Kohlhepp

23-Emerald I

@ftatl63 wrote:

Hi all,

For the attached sheet, I am trying to calculate the mid-point of each layer using an if statement. The values are entered using an Excel table. For the first layer, the mid-point is simply H0/2 (so 0.9 m). For the second layer, the mid-point is the previous mid-point, plus the average of the previous and current points (so, 0.9 m + (1.8+1.6)/2 = 2.6 m). For some reason however, the simple IF code I am trying to use doesn't seem to work. I am not very familiar with programming in Mathcad, so any help would be appreciated.

Thanks!

-Fikret

Why isn't the midpoint of the second layer half the thickness of the second layer plus the whole first layer?

(1.8 + 1.6/2)

Translate