Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Jeff Cunningham on Oct 12 In MS Office Category.

Can I make all negative numbers have a value of zero?

Question Answered By: Eshe Chalthoum on Oct 12

Cell A1 contains the number 2
Cell B1 contains the number 3

The following formula subtracts B1 fron A1
Cell C1 contains the formula =IF(A1-B1<0,0,A1-B1)

View Complete Question Thread

Didn't find what you were looking for? Find more on Can I make all negative numbers have a value of zero? Or get search suggestion and latest updates.

Related Topics:

Change every second column to a negative number
if condition with negative value
Macro to Suppress Rows w/ Zero Value
Want chart not to plot zero values?
Converting a "Stringed" Number to a Number
Compute the sum of both positive and negative elements of an array
Ratio of positive and negative text in learning dataset for text classification?
Converting a "Stringed" Number to a Number
vba routine for eliminating rows with all zeros from spreadsheet
Matching date values w/ dropdown values
Looping thru values to match w/ other values
Reading Binary Files with Leading Binary Zeros
VBA to Change value in column AQ based on values in I, and AI
Too many Zeros
free resource, assumes zero Linux knowledge
For making a new tutorial webste
Really Need Help making a half pyramid
making rpm
Steps for Making JDBC connection
when making a USB startup disk

Tagged:can make all negative numbers have value of zero

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us