Change excel formula [Closed]

Report
Posts
3
Registration date
Tuesday October 13, 2009
Status
Member
Last seen
October 15, 2009
-
Posts
3
Registration date
Tuesday October 13, 2009
Status
Member
Last seen
October 15, 2009
-
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 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4198 users have said thank you to us this month

Posts
3
Registration date
Tuesday October 13, 2009
Status
Member
Last seen
October 15, 2009

Thank you so much. Finally I see 0's instead of negative numbers, thank you so much, I really appreciate your help.
Joeleene