IF OR Statement for Adjusted Book & Market Values

[lynchbro]

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.

[Pecoflyer]

Do you mean something like

=IF(and(N2=0,P2=0),I2,I2+O2-Q2)

?

[lynchbro]

No because there most instances will have N=0 & P=VALUE or vice versa.

[Pecoflyer]

I don't understand what you are trying to do

[lynchbro]

Hi Pecoflyer. Thank you for trying to help. I found a work around that didn't require the formulas.