| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
cell equation ?
jahoobob Wrote: Formula in d12 should be =If(b12-c120,0,b12-c12) Thanks for the help but I am still having an issue with this. b12=11 c12=21 d12=b12-c12 so then d12 should equal -10 but I need it to equal 0 I also need to account for 0's in the b or c column and I still need it to display positive positive results. Thank You ws d -- Custermd |
|
#2
|
|||
|
|||
|
Custermd Wrote: Thanks for the help but I am still having an issue with this. b12=11 c12=21 d12=b12-c12 so then d12 should equal -10 but I need it to equal 0 I also need to account for 0's in the b or c column and I still need it to display positive positive results. Thank You ws d Apologies, I made the same mistake Marcster did in posting my formula, it should be: =IF(B12-C12<0,0,B12-C12) -- jahoobob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| macro help | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
