| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count if a number in a cell
"JC-PS" wrote: =IF(L8="",G8<0,IF(M7<0,-M7*D2*2,L8)) any how working better even when M7 is a negative or a positive number, incl 0. ;D A correction, =IF(L8="",G8<0,IF(G7<0,G7*D2*2,L8)), much better :D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of changes to a cell | Excel Worksheet Functions | |||
| How can I count the number of characters on a cell? | Excel Discussion (Misc queries) | |||
| count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Count the number of words in a cell! | Excel Worksheet Functions | |||
Hybrid Mode
