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!