Skip to main content
Solved

IF Formula - Take value from cell then modify

  • September 13, 2023
  • 2 replies
  • 75 views
Huhviss
Forum|alt.badge.img+2

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 😊

Best answer by Sho

Hi @Huhviss ,

This is what you mean?

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

 

This topic has been closed for replies.

2 replies

S
Forum|alt.badge.img+24
  • Sho
  • Inspiring
  • Answer
  • September 13, 2023

Hi @Huhviss ,

This is what you mean?

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

 

    Huhviss
    Forum|alt.badge.img+2
    • Huhviss
    • Author
    • New Participant
    • September 13, 2023

    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 🙂

    Terms & ConditionsAccessibility statement