IF Function help

Closed
Report
Posts
1
Registration date
Friday February 13, 2015
Status
Member
Last seen
February 13, 2015
-
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
-
Hello,
I am working on a spread sheet whereby one cell contacts REV and RP and I then want the amount linked to that row to become a negative figure
Can you help?
Thanks

1 reply

Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
If I understand, it's a matter of looking down a set of columns where one column says REV and another Column says RP and where those to conditions match you want a cell to change from a positive to negative number.

If A1 is the one with REV, B1 is the one with RP and C1 is the number you wish to change signs, try something like this.

=if(and(A1="REV", B1="RP"),C1*-1,C1*1)
That will change the sign only if the two conditions are met and will show the unchanged value when not met.
or
=if(and(A1="REV", B1="RP"),C1*-1,"")
That will change the sign only if the two conditions are met and be blank when not met.

Hope that helps