Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Marcster Wrote: Hi Custermd, Is this what your after: =IF(b600,0,b6) Doesn't seem to post correctly on this forum. Should read: =IF(CELL is less than {LEFT ARROW}0, Then Display 0, else display the CELL) Marcster. Sorry could not get the eq to work. Here is a more specific ex. b12=11 c12=21 d12=b12-c12 so then d12 should equal -10 but I need it to equal 0 -- Custermd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro help | Excel Discussion (Misc queries) | |||
Cell Change Color - Need Help | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |