Quote:
Originally Posted by GS[_2_]
Try this in F3...
=IF(OR(AND($E30,$H3),AND($E3<0,NOT($H3))),$C3*$E3 %,$C3)
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public. vb.general.discussion |
Thank you Garry. I wound up with this, which also seems to do the job:
=IF(F3="False",-C3,C3*(ABS(E3)/100)^SIGN(E3))
Thanks again!