Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF Formula - Take value from cell then modify

Topic Labels: Formulas
Solved
Jump to Solution
906 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
)

 

Huhviss
4 - Data Explorer
4 - Data Explorer

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