#1
|
|||
|
|||
Formula
how can make formula for this if cell E6 if greater than 0 than the value as its
and if its less than 0 than 0 (no negative numbers) can somebody please help? |
#2
|
||||
|
||||
=max(0,e6)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help with formula | zachluke | Excel | 3 | 03-13-2014 11:15 AM |
WHEN formula | agent007 | Excel | 5 | 02-06-2014 09:20 PM |
formula help | excelledsoftware | Excel | 8 | 03-25-2012 08:49 AM |
Formula help | furface00 | Excel | 10 | 02-26-2012 05:34 AM |
If formula | sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |