| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiply (C8-C4) by B10 to display positive only i.e. C8>=C4
|
|
#2
|
|||
|
|||
|
Hi
=IF(C8=C4,(C8-C4)*B10,"") or =ABS(C8-C4)*B10 depending on what you're acutally asking (its a good idea to write a bit in the message body about what it is you're trying to achieve) -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "seamusdoherty" wrote in message ... |
|
#3
|
|||
|
|||
|
|
|
#4
|
|||
|
|||
|
LOL!
Gord On Wed, 4 May 2005 08:05:29 -0700, "RagDyeR" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Workaround for Cell Display Limitation in Excel 2000 | Excel Discussion (Misc queries) | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
| How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Linear Mode
