Thread: Excel formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tom Rasch Tom Rasch is offline
external usenet poster
 
Posts: 1
Default 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.