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
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
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
Related:
- Change excel formula
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
2 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 15, 2009 at 06:49 AM
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)
"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)
joeleene
Posts
3
Registration date
Tuesday October 13, 2009
Status
Member
Last seen
October 15, 2009
Oct 15, 2009 at 10:28 AM
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
Joeleene
