|
|
#2
05-28-2016, 09:59 PM
|
||||
|
||||
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] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Help with if then statements
|
brent chadwick | Word VBA | 35 | 07-25-2015 02:41 PM |
|
Using IF statements
|
stuwoolf | Excel | 2 | 01-10-2015 01:58 PM |
|
count if statements
|
Alaska1 | Excel | 1 | 05-14-2014 08:21 AM |
| Multiple If statements | bremen22 | Excel | 2 | 10-15-2013 06:37 AM |
| IF statements that shifts to right. | kent | Excel | 0 | 01-19-2006 02:23 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode