Posted to microsoft.public.excel.misc

Mukesh

external usenet poster

Posts: 78

How to get -ve from +ve calculation?

I need to calculate margin required for trading,
if there is 1 buy & 1 sell, I need result as 1 & -1,
for example:

cell
A7 buy B7 1
A9 buy B9 1
A10 sell B10 2

So far my formula in cell H10 is :
=IF(OR(A10="buy",A10="sell"),ROUND(((H$3*B10)*1000 *0.05)*C10,2)," ")

how do I make it work to give me a -ve result? please help.

Thanks.
Mukesh

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multi threaded calculation (multi CPU) - impact on calculation spe	Pascal[_2_]	Excel Discussion (Misc queries)	1	December 3rd 08 10:46 AM
If Calculation	skateblade	Excel Worksheet Functions	4	May 31st 06 12:03 PM
Age calculation	Clash	Excel Discussion (Misc queries)	5	March 17th 06 07:16 PM
How do I use a rounded calculation result in another calculation?	vnsrod2000	Excel Worksheet Functions	1	January 26th 05 10:11 PM
How do I use a rounded calculation result in another calculation?	vnsrod2000	Excel Worksheet Functions	1	January 26th 05 09:36 PM

All times are GMT +1. The time now is 06:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us