MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formula


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


Posted by B. Dewey on June 12, 2001 2:42 PM


Posted by IML on June 12, 2001 2:58 PM

Thanks BD

If I understand correctly, give

=IF(OR(K10>499,AND(K10>299,B10="u")),"yes","no")

a try.

good luck


Posted by Russell on June 12, 2001 2:59 PM

Thanks BD


If I understand what you are saying, try this:

=IF(OR(K10>499,AND(B10="u",K10>299)),"YES","")