...........
Last edited by PowerZ; 11-19-2010 at 01:32 PM.
=IF(A1>100,A1-100,0)
Regards
An alternative =max(A1-100,0)
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
@arthurbr: wot, no Code Tags!? :-(
Since when is a formula the same as code??
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
TM,
the forum rules require code tags for VBA code only. The rules explain why.
Sometimes it's beneficial to use code tags for formulas, too, since the forum software will insert a space after 100 characters of continuous text without blanks, hence possibly rendering a formula faulty or useless for copy and paste.
Therefore, many members will post formulas in code tags, too, since code tags will prevent the insertion of spaces in long formulas. This does not mean that code tags are mandatory when posting formulas, though.
cheers,
Ta ;-))
Wow! Thank's for the help guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks