IF Function help

Closed
Stella1977 Posts 1 Registration date Friday February 13, 2015 Status Member Last seen February 13, 2015 - Feb 13, 2015 at 06:18 AM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Feb 20, 2015 at 10:16 AM
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

cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 7
Feb 20, 2015 at 10:16 AM
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
0