# Re: IF Formula - Take value from cell then modify

Solved
463 0
cancel
Showing results for
Did you mean:
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
11 - Venus

Hi @Huhviss ,

This is what you mean?

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

2 Replies 2
11 - Venus

Hi @Huhviss ,

This is what you mean?

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

4 - Data Explorer

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