Can I be able to do this?

[transkawa]

Hello. I want to carry out a conditional calculation using IF function
such that it the logical test on IF function returns true or false I can
be able to insert new value into one of two alternative cells.
Like, I have two ranges to sum, range A and range B. If range A if
greater than B, I do a subtraction operation and insert the value into
cell A10 but if range A is lesser than range B, I still do a subtraction
operation but this time insert the value into a different cell, cell
B10.
Can anyone show me how?

 

[Pete_UK]

Put this in A10:

=IF(SUM(rangeA)>=SUM(rangeB),your_subtraction,"")

and this in B10:

=IF(SUM(rangeA)>=SUM(rangeB),"",your_subtraction)

Hope this helps.

Pete