IF Formula - Take value from cell then modify

[Huhviss]

Hi All,

I'm having an issue figuring out how to best format a formula for my situation. 
This is probably very simple but I need a hand. 

Here are my fields:
"Total" - Currency field with numeric value
"Total Copy" - Formula Field 
"Is Income?" - Single Select field

Basically, I need Total Copy to take & convert Total's value to a negative or positive number based on Is Income.

I have this so far to grab from Total and make it a negative: IF({Is Income?} = BLANK(), {Total} *-1, "") 
But now I need it to also recognize if Is Income is not empty so it can copy from Total and deliver a positive value instead of staying blank in that case.

Any help is appreciated 😊

[Sho · Accepted solution]

Hi @Huhviss ,

This is what you mean?

IF(
  {Is Income?},
  {Total},
  {Total}*-1
)

[Huhviss]

Exactly what I mean! Thanks so much. I think I was just overcomplicating it in my head 🙂