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
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Feb 20, 2015 at 10:16 AM
Related:
- IF Function help
- Find function on mac - Guide
- Accessor function c++ - Guide
- Spreadsheet function - Guide
- Agp function - Guide
- Hard drive function - Guide
1 response
cmarzahn
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Feb 20, 2015 at 10:16 AM
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
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
