View Single Post
 
Old 06-03-2011, 01:54 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi Rey,

Your calculations may be set to manual. If that's the case then change them to automatic.

For reference, the IF(condition, TRUE) isn't required in your formula, since AND() returns TRUE/FALSE anyway. You could simplify to either of these:

=AND(OR(C4="PRO",C4="SER"),H4=1,I4=0)

=AND(OR(C4={"PRO","SER"}),H4=1,I4=0)
__________________
Colin

RAD Excel Blog
Reply With Quote