how to simplify this if statement

[gauthamchilled]

hi all

i have this condition, regardless of revenue if profit is positive number i have to show +ve margin otherwise negative number

how can I achieve this?

if sum(profit) < 0 and sum(revenue) < 0, -(sum(profit)/sum(revenue)

if sum(profit) < 0 and sum(revenue) > 0, -(sum(profit)/sum(revenue)

if sum(profit)> 0 and sum(revenue) < 0, (sum(profit)/sum(revenue)

if sum(profit)> 0 and sum(revenue) > 0, (sum(profit)/sum(revenue)

can you simplify the above if statement?

Regards

Gautham

[Anil_Babu_Samineni]

May be this?

if(RangeSum(profit, revenue) < 0, -RangeSum(profit,revenue),

if(sum(profit) < 0 and sum(revenue) > 0, -RangeSum(profit, revenue)

if(sum(profit)> 0 and sum(revenue) < 0, RangeSum(profit,revenue)

if( RangeSum(profit, revenue) > 0, RangeSum(profit,revenue)))))