Help with IF, AND, THEN formula

[Jsimpson19]

Good Evening

I could use some help on my attached workbook. I am having in issue with tab "spray logs" row 968 and below with getting a #value error. I am assuming I need to add another "IF" into my formula but cant seem to figure it out. If both Area/volume and Area/rate are = 1000/sqft it is not giving me a sum. Basically we applied 20 lbs per 1000/sqft the gallons mixed should say 40 lbs. We used half the bag so in gallons sprayed we inserted .5 which should sum up to 20 in the TOTAL CHEMICAL APPLIED column.


Thanks in advance

[skywriter]

I haven't analyzed your formula completely, your formula is dividing by Q968 which has the word "Broadcast" in it. At first glance I thought it was O968 because you have to really look close to see it's a Q.
Correct that and see if that helps. If not I'll check it again, or I'm sure someone else will.

[sandy666]

deleted because correct answer exist

[Jsimpson19]

I'm sorry but that did not work also. If you look at Row 955 I have the word DRENCH in but the AREA/VOLUME is 100g. If I change my AREA/VOLUME to in 968 I do not get the #value! anymore but the total is not correct that is why I am thinking I need to add another set of equations into my formula. Basically if 1000/sqft is in both R and O then it would need to be P divided by O.

[sandy666]

from the top you trying this: number / text

[vlady]

as sandy is saying Q has text

how do you compute:

if they are same O and R ="1000/sqft" or "acre" values = ?
if they are NOT the same = ?
if O is 100/gal =?
if O is gal =?
use the column header as basis like rate *gallon sprayed

[Jsimpson19]

I'm sorry and I hope you are not getting frustrated with me but I do not understand how Row 955 is not giving me the error as in the formula it is still dividing a number/text. I don't know why it would make a difference whether is was the word DRENCH and not BROADCAST. that is why I am assuming it is because this is the first time we have had a chemical that the AREA/VOLUME and AREA/RATE are both 1000/sqft and that was not built into the formula as being an IF statement

[sandy666]

IF(logical_test,A,B)

if logical_test = true , display A, pass over (don't check) B
if logical_test = false, display B, pass over (don't check) A

[vlady]

based on your if statement
if they are the same acre or 1000 sqft

M970*S970/Q970 that is
rate * gallon sprayed divided by gallon per area
M*S/Q
the Q970 contains text broadcast
say
M= 20
S = 2
Q = broadcast

=20*2/broadcast -> error since you are dividing the number with the text "broadcast"
look post #6 and show what will be the computation needed.

[SDCh]

Dear Jsimpson,

How you calculate text? Excel only calculate number like calculator.

Use evaluate formula on tab formula if you want to know how your formula working.