Multiple IF conditions

[Lestat]

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 multipl
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 eithe
be true or false. If it's true AND E3 is a positive number, then
simply want F3 to show (C3*E3%). If it's false, then I want it to sho
C3. However, if F3 is false and E3 is a negative number, then I nee
(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 thi
might be too many conditions to satisfy. I'd really appreciate any hel
with this. Thanks

 

[GS]

Try this in F3...

=IF(OR(AND($E3>0,$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

 

[Lestat]

;1611305']Try this in F3..

=IF(OR(AND($E3>0,$H3),AND($E3<0,NOT($H3))),$C3*$E3%,$C3

--
Garr

Free usenet access at http://www.eternal-september.or
Classic VB Users Regroup
comp.lang.basic.visual.mis
microsoft.public.vb.general.discussio

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]

;1611305']Try this in F3...

=IF(OR(AND($E3>0,$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