Hi:
I need some help with a formula for a tax worksheet I building.
I have a situation where in Cell E87 I could have either a Loss (..negative #) or a Gain (..positive #). In Cell E88, I need to do the following:
If Cell E87 is a Loss (..negative #), Enter the smaller of:
(a) the Loss in Cell E88
(b) $3000 ($1500 if Cell C67 = "MFS" )
Any help is appreciated.
Thanks a million times
I need some help with a formula for a tax worksheet I building.
I have a situation where in Cell E87 I could have either a Loss (..negative #) or a Gain (..positive #). In Cell E88, I need to do the following:
If Cell E87 is a Loss (..negative #), Enter the smaller of:
(a) the Loss in Cell E88
(b) $3000 ($1500 if Cell C67 = "MFS" )
Any help is appreciated.
Thanks a million times