Excel formula

[Tom Rasch]

I am trying to do a formula that says if H5 = 0 then H7 should display 0,
however if H5 >0 run the following formula in H7, (H5-$H$2)*10000

To complicate matters i also need for the above formula to run if E2 is
true. If E2 is false the formula needs to be ($H$2-H5)*10000.

I am pretty good with Excel and figuring out what i need but i may have gone
overboard on this one.

 

[Jacob Skaria]

Do you mean

=IF(OR(H5+0<>0,E2=FALSE),(H5-$H$2)*10000,IF(E2=FALSE,(H2-$H$5)*10000,0))

If this post helps click Yes

 

[Jacob Skaria]

Should be

=IF(OR(H5+0<>0,E2=TRUE),(H5-$H$2)*10000,IF(E2=FALSE,(H2-$H$5)*10000,0))


If this post helps click Yes