Excel formula
 

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.

Excel formula
 

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


"Tom Rasch" wrote:

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.

Excel formula
 

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
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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


"Tom Rasch" wrote:

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.