Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get -ve from +ve calculation?
Just put a - sign in front of the word ROUND, as
=IF(OR(A10="buy",A10="sell"),-ROUND(((H$3*B10)*1000*0.05)*C10,2)," ") But I'm not sure your OR statement is correct. Can you just write out how things should work, like If A10="buy" or A10="sell" then do this math (formula here) but if A10 is not either buy or sell, then put a blank space there. Reason I think the OR may be wrong is that you talk about having 1 buy and 1 sell and needing 1 and -1 results and I am thinking that you really want two different cells referenced in it, as =IF(AND(A10="buy",A11="sell"),ROUND(((H$3*B10)*100 0*0.05)*C10,2)," ") but I just am not certain of exactly what you are looking for. "Mukesh" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
If Calculation | Excel Worksheet Functions | |||
Age calculation | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |