![]() |
|
#1
|
|||
|
|||
![]() I am using an IF OR statement to create an adjusted book value of a holdings report. Due to system output of the original holdings, there are rounding in the market value & unrealized gain loss calculations. I will need to use excel to create an adjusted holdings but using the unrounded versions for cost, market value & unrealized. My formula is: =IF(OR(N2=0,P2=0),I2,I2+O2-Q2) N2 is new purchase quantity P2 is new sale quantity I2 is original book value O2 is new purchase book value Q2 is new sale book value The way the formula is written above it is only calculating correctly if there is both new purchase & sale quantity >0. I need it to be one or both >0. Then the same goes for the adjusted market value column: =IF(OR(N2=0,P2=0),J2,H2*N2-H2*P2+J2) N2 is new purchase quantity P2 is new sale quantity J2 is original market value H2 is current day price Again the way the formula is written above it is only calculating correctly if there is both new purchase & sale quantity >0. I need it to be one or both >0. If needed I can attach an example sheet to better illustrate. |
#2
|
||||
|
||||
![]()
Do you mean something like
Code:
=IF(and(N2=0,P2=0),I2,I2+O2-Q2)
__________________
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 |
#3
|
|||
|
|||
![]()
No because there most instances will have N=0 & P=VALUE or vice versa.
|
#4
|
||||
|
||||
![]()
I don't understand what you are trying to do
__________________
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
|
|||
|
|||
![]()
Hi Pecoflyer. Thank you for trying to help. I found a work around that didn't require the formulas.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Where Can I Download Free Go To Market Plan PPT? | Davidsmith2 | PowerPoint | 2 | 09-27-2015 09:50 PM |
Add a statement | sma | Word | 6 | 03-23-2014 10:30 AM |
Page layout can't be adjusted | geaker | Word | 0 | 10-12-2010 07:46 AM |
![]() |
piper7971 | PowerPoint | 1 | 08-19-2010 07:10 AM |
![]() |
CPelkey | Word | 1 | 04-12-2010 09:06 AM |