How to use if/then for a calculation field
I'm trying to create a fillable form that has a simple calculation for work. The calculation involves 2 fields, and I can get it to run in Excel, but Acrobat just weirds out any time there are 0s involved - I know its a calculation problem.
So here is the scenario. I have a field called 'Acres1', and a field called "WAF1". My results field is called "WAI1". There are potentially 10 lines of this code (Acres2, Acres3,...WAF2, WAF3...etc).
My formula works under simple calculation as ((WAF1/12)/Acres1) so long as Acres1 and WAF1 are populated with numbers. However, everything bombs out with error boxes if both or either of those fields are not populated - and I won't always have the whole 10 lines of data populated. I've been banging my head against the wall all afternoon trying to figure this out, and to no avail.
Help!!!
