|
|
#1
05-12-2017, 12:37 AM
|
|||
|
|||
nested IF formula question
Hi
C2, D2.....L2 hold prices N2 holds max of C2:L2 O2 holds min of C2:L2 P2 holds (N2-O2)/8 My formula in R2:- =IF(C2=O2,0,IF(C2=N2,9,INT((C2-O2)*P2))) but I get a zero when C2 does not equal either N2 or O2? What am I doing wrong? Last edited by H28Sailor; 05-12-2017 at 12:38 AM. Reason: correction 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date
|
mshu31 | Word | 1 | 02-09-2017 02:04 PM |
| nested formula using IF & AND | paxon | Excel | 3 | 02-18-2016 05:32 AM |
|
Formula Question
|
glhatch | Excel | 1 | 01-23-2015 04:13 PM |
|
Complex formula question
|
diverdown87 | Excel | 7 | 10-21-2014 07:44 AM |
| Formula question | H28Sailor | Excel | 4 | 08-20-2013 09:57 AM |
Windows 7 32bit 
Office 2007
Threaded Mode