Hi Gurus,
I've got a table with some stock symbols and details in it.
The formula i'm using to work out capital gains tax rates on it is as follows.
=IF([@[Purchase date]] <=TODAY()-365, H14/2*0.38, H14*0.38)
which works fine, so long as "H14" is a positive value, as this value is used in another column to work out profit after tax.
can i use my formula, with another OR operator to return a zero if the result is negative? I have tried doing the following.
=OR(IF([@[Purchase date]] <=TODAY()-365, H14/2*0.38, H14*0.38),IF(h14 <=0, 0, ...... but then i lose my way, i'm unsure how to get the original value if it returns false.
Bookmarks