Can anyone explain why this wont work or if its possible? I want to tell excel if one cell is a "W" then multiply another cell by 1, if it is not a "W", then multiply it by negative one. Here is what I tried to do:
=IF(G16=W, E16*1, E16*-1)
Help?
Can anyone explain why this wont work or if its possible? I want to tell excel if one cell is a "W" then multiply another cell by 1, if it is not a "W", then multiply it by negative one. Here is what I tried to do:
=IF(G16=W, E16*1, E16*-1)
Help?
you need quotes around the W
Try
=IF(G16="W", E16*1, E16*-1)
Life's a spreadsheet, Excel!
Say thanks, Click *
Duh. Sorry to waste your time. Thanks for the help!
You're welcome...
You didn't waste our time...
We're reading the forum whether you post this thread or not..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks