Need help with excel formula greater than..
I want a formula to do this.
I am calculating how many gallons i pumped i have two wells only one well runs a day, alternating each day.
column A is hours well one ran Column B is hours well 2 ran in column C is the total gallons pumped from one of the wells 1 or 2 which ever ran that day. I want column D to reference how many gallons pumped from column C but only if Column A had a number greater than 1 how do i do this?
|