Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here is an equation I'm using to calculate intersection sight
distance: ISD = 1.47 (Vmajor) [T + (G - 3%)0.2 + (W/12)0.5] Each variable will be a cell, for instance, G could be B12. When G is less that 3%, I don't want it to do that part of the equation. The actual value of G could be 2.57%, but when it is, I don't it to "subtract 3%, then mult. by .2 In the EQUATION, i want that term, (G - 3%)0.2, to be a minimum of zero. See, when G is less than 3%, that whole term is negative, and i don't want that. Can anyone help me think of a way to not do that part of the equation when G < 3%? Is there some Excel function I'm not thinking of? I'm trying to avoid tons of nested IF statements. Much appreciated, dk |