Help

IF Formula - Take value from cell then modify

Topic Labels: Formulas
Solved
Jump to Solution
797 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Huhviss
4 - Data Explorer
4 - Data Explorer

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 😊
1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi @Huhviss ,

This is what you mean?

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

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

Hi @Huhviss ,

This is what you mean?

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

 

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