ajyexcel
New member
- Joined
- Dec 17, 2020
- Messages
- 10
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
Hi Forum Members ,
Im new to excel . I need a help here . Im trying to write a formula whenever there is a negative number on one particular column ,the value should be cancelled Sale and when positive a different text value, but when that particular column ( Calculated Value) is blank, it should not return anything . The result should be blank
Right now im using this formula --
=IF([@[Calculated Value]] > 0,"Mutual Release","Cancelled Sale")
Im new to excel . I need a help here . Im trying to write a formula whenever there is a negative number on one particular column ,the value should be cancelled Sale and when positive a different text value, but when that particular column ( Calculated Value) is blank, it should not return anything . The result should be blank
Right now im using this formula --
=IF([@[Calculated Value]] > 0,"Mutual Release","Cancelled Sale")