Previous Topic Next Topic

Change excel formula

Closed
joeleene Posts 3 Registration date Tuesday October 13, 2009 Status Member Last seen October 15, 2009 - Oct 14, 2009 at 12:57 AM
joeleene Posts 3 Registration date Tuesday October 13, 2009 Status Member Last seen October 15, 2009 - Oct 15, 2009 at 10:28 AM
Hello,
Below is the current formula in the Tax column of my spreadsheet.
=ROUND(IF(D5<342,(((D5+0.99)*0.15)-29.7115),((IF(D5<402,(((D5+0.99)*0.25)-63.9308),((IF(D5<576,(((D5+0)*0.165)-29.7117),(((D5+0.99)*0.185)-41.2502)))))))),0)
I want to amend this formula so it only shows a value if it is >0 otherwise it will just show 0 or even better still the word NONE.
How can I amend this formula to do that?
Thank You
Joeleene

2 responses

Answer 1 / 2
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 15, 2009 at 06:49 AM
Hello

"I want to amend this formula so it only shows a value if it is >0 otherwise it will just show 0"
use =MAX(0, YOURFORMULA)

"even better still the word NONE. "
use =if(YOURFORMULA<0,"NONE",YOURFORMULA)
1
Answer 2 / 2
joeleene Posts 3 Registration date Tuesday October 13, 2009 Status Member Last seen October 15, 2009
Oct 15, 2009 at 10:28 AM
Thank you so much. Finally I see 0's instead of negative numbers, thank you so much, I really appreciate your help.
Joeleene
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response