mushrat Posted October 22, 2010 Share Posted October 22, 2010 Hey, I have a formula, (b17)-1500. I want it to just show a 0 if the number is negative. Can anyone help me? Link to comment Share on other sites More sharing options...
Stuie Posted October 22, 2010 Share Posted October 22, 2010 [font="Arial"][size="2"][color="#000000"]=IF((B17)-1500<0,0,+(B17)-1500)[/color][/size][/font] Link to comment Share on other sites More sharing options...
mushrat Posted October 23, 2010 Author Share Posted October 23, 2010 awesome..ill try it monday. Thanks man. Link to comment Share on other sites More sharing options...
Travis Posted October 23, 2010 Share Posted October 23, 2010 [quote name='Stuie' timestamp='1287778253' post='485963'] [font="Arial"][size="2"][color="#000000"]=IF((B17)-1500<0,0,+(B17)-1500)[/color][/size][/font] [/quote] wait a second.......red fish.....blue fish......what comes after [font=Arial][size=2]=IF((B17)-1500<0,0,+(B17)-1500) fish?[/size][/font] Link to comment Share on other sites More sharing options...
mushrat Posted October 26, 2010 Author Share Posted October 26, 2010 that worked. Thanks again. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now