Solved: Help Not VBA

[FF Ethan]

Ok I have no clue how to do this probably a dumb question.
I work with water spreadsheets and my boss asked me to figure out a forumula (preferably easy to change) to take the formula we already have whick uses 8 Gallons per minute per acre and change only a few fields to 4.5 gallons per minute per acre and i have no clue how because the formula we use is just spreading the water flow evenly can anyone help im stuck. Here is the exact formula =IF(Acrehrs.>0,Acrehrs./$totalacrehrs*$totalgallons,0)
??????? Does any of this make sense?

[Aussiebear]

Not without seeing your workbook

Click on Go Advanced, Manage Attachments and upload a sanitised version of your workbook.

We will need to see how you work out AcreHrs, total AcreHrs and totalGallons

Normally an IF statement is written in the following format

=IF( test, Value if True, Value if False)

In this case your formula as you have written it

=IF(AcreHrs>0, AcreHrs, /totalAcreHrs*TotalGallons,0)

according to my understanding, will fail if the value of AcreHrs is zero

[FF Ethan]

Am I able to do that in Excel 2003?

[Aussiebear]

Absolutely

[FF Ethan]

Here it is this is where the hours get inputed and the gallons get distributed evenly.

[FF Ethan]

Here is the formula i came up with (doesnt work)
=IF(B5>0,B5/$X5*$A5/8*4.5,0)
But A3 Needs to have the same value as X6.
Im stuck!!!!!!!
Please help.

[Zack Barresse]

So are there certain fields where the sprinkler package is engineered to 4.5 GPM then? I thought they were all bored for 8 GPM? If not, how do you know which one's aren't?

[FF Ethan]

They used to be.
Now they have a sprinkler package that they can change from 4.5 to 8.
They send us a paper that says which ones are and which ones arent.

[FF Ethan]

Ok, well my boss decided to go in a different direction with this thanks anyway.