|
|
#4
05-12-2017, 09:32 AM
|
||||
|
||||
Just remove the INT function =IF(C2=$O2,0,IF(C2=$N2,9,((C2-$O2)*$P2)))
It returns the integer part and as all your differences are lower than 1 you always get 0 which is the integer part of any number between 1 and 0
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
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 64bit 
Office 2010 64bit
Threaded Mode