A BIG THANK YOU to Brian Barker and Johnny Rosenberg as being
instrumental in solving the problem by giving me the knowledge I needed
to sort out the issue.
Bravo guys and Thanks again
Hylton
--
Hylton is a Lions Club
Brian,
Thank you, and sorry for the double post of this message.
The calculation you provided worked perfectly after correctly
identifying the necessary cells to be used. funny though the same
formula does not work just 2 columns to the left? See below and I am
sure identify the cause as I
Hi,
I have a formula below which is giving me an Err: 502 on Calc 3.4.5 when
I try and calculate a currency total using a sliding scale.
=SUMIF(b6c2,d2,0),(IF(b6-c2)c3,d3,0),(IF(b6-c2-c3)c4,sum((b6-c2)-c3)*b4,0
Each IF statement outs only a single answer and all I want to do is SUM
At 16:35 02/02/2013 +0200, Hylton Conacher wrote:
I have a formula below which is giving me an Err: 502 on Calc 3.4.5
when I try and calculate a currency total using a sliding scale.
=SUMIF(b6c2,d2,0),(IF(b6-c2)c3,d3,0),(IF(b6-c2-c3)c4,sum((b6-c2)-c3)*b4,0
That's not surprising.
