Hi,

I tried using the search feature, but could not find the answer I need. I'm working on a spreadsheet where I need to satisfy multiple conditions.

Cell C3 is a manually entered amount that will be used with cell E3, which is also a manually entered amount.

EX: C3=25 and E3= either 150 or -150 (manually entered).

If E3 is a positive number then C3 is multiplied by E3% in cell F3.

EX for F3: IF(E3=0,C3*E3%,C3/E3%

So far, so good. But now I have another condition in H3 that will either be true or false. If it's true AND E3 is a positive number, then I simply want F3 to show (C3*E3%). If it's false, then I want it to show C3. However, if F3 is false and E3 is a negative number, then I need (C3*E3%) and if E3 is a positive number then C3.

I hope this makes sense to someone as it barely makes sense to me :). I'm also not sure it's even possible to do this in one cell as this might be too many conditions to satisfy. I'd really appreciate any help with this. Thanks!

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!

'GS[_2_ Wrote:
;1611305']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!

Glad you got it sorted...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion