Date: 2012-05-12 10:10 pm (UTC)
Maybe split it into two cells. Have your formula as above, but then use a second step to check if it's negative or not using a simple IF statement.

Or is there an ISNEGATIVE function? I can't remember.
This account has disabled anonymous posting.
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting

Profile

philmophlegm: (Default)
philmophlegm

March 2017

S M T W T F S
   1234
56 7891011
12131415161718
19202122232425
262728293031 

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jun. 14th, 2025 02:34 pm
Powered by Dreamwidth Studios