Can I be able to do this?

  • Thread starter Thread starter transkawa
  • Start date Start date
T

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?
 
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
 
Back
Top