Posted by B. Dewey on June 12, 2001 2:41 PM
=IF(Total Pledge>499,"yes","")here is my beginning formula.
This formula is in m10, total pledge is in k10. When m10, which also has a sum formula in it equal 499 a yes will appear in m10.
how do I add to it for these additional conditions.
I want it to also reflect a yes if the total pledge is >299 as long as the b10 column contains a u.
If k10 has greater than 499 in it it will relect a yes in m10, or if k10 is greater than 299 but only if there is a u in b10 then it can also reflect a yes in m10.
Is this possible? What would the formula be? Thanks BD