Hoopsah
03-07-2013, 07:12 AM
Hi,
I have attached a copy of the spreadsheet I am trying to work out a calculation on.
I want to calculate the band width of a pipe given certain criteria.
=IF($C$20<C37,C37-$C$20,0)
Works and gives me the correct result, however, want I want to incorporate is a further condition, so that the fomulas will say:
If C20 < C37, then, C37 - C20, but, If C20 is less than C37 then no other calculations are necessary as it will always be smaller than the other options.
So, if the calculation gives a result then no other calculations are required and should state zero.
Hope this makes sense, any help appreciated,
Cheers
Hoopsah
I have attached a copy of the spreadsheet I am trying to work out a calculation on.
I want to calculate the band width of a pipe given certain criteria.
=IF($C$20<C37,C37-$C$20,0)
Works and gives me the correct result, however, want I want to incorporate is a further condition, so that the fomulas will say:
If C20 < C37, then, C37 - C20, but, If C20 is less than C37 then no other calculations are necessary as it will always be smaller than the other options.
So, if the calculation gives a result then no other calculations are required and should state zero.
Hope this makes sense, any help appreciated,
Cheers
Hoopsah