Thread: [Solved] Error in If statements
View Single Post
 
Old 05-28-2016, 09:59 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Your formula isn't valid. Try:
=IF(J18=76,13,IF(J18=89,20,0))*P18
You need to provide an 'else' result for cases where J18 isn't either 76 or 89. I've put a 0 in the formula where that should go.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote