![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
Cannot replicate that problem.
For me your formula works just fine. |
#3
|
|||
|
|||
![]()
worksheet attached
|
#4
|
||||
|
||||
![]()
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 |
#5
|
|||
|
|||
![]()
Thank you
![]() |
#6
|
||||
|
||||
![]()
Most welcome
__________________
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
mshu31 | Word | 1 | 02-09-2017 02:04 PM |
nested formula using IF & AND | paxon | Excel | 3 | 02-18-2016 05:32 AM |
![]() |
glhatch | Excel | 1 | 01-23-2015 04:13 PM |
![]() |
diverdown87 | Excel | 7 | 10-21-2014 07:44 AM |
Formula question | H28Sailor | Excel | 4 | 08-20-2013 09:57 AM |