Hi,

I require an if function that could do the below. I have tried an if
function but can only gat it to work for the first 2 but not for all.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 C25=X7.50
C15=5.50 C25=X7.50 but show as a minus figure.

Any help would be appreciated.
Thanks
Haz

Not sure what the X7.50 results are supposed to be, so I will leave that up
to you.
C25: =IF(OR(C15=0,C15=5.5),0,IF(C15<5.5,X7.50,-X7.50))
--
** John C **


"Haz" wrote:


Hi,

I require an if function that could do the below. I have tried an if
function but can only gat it to work for the first 2 but not for all.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 C25=X7.50
C15=5.50 C25=X7.50 but show as a minus figure.

Any help would be appreciated.
Thanks
Haz

I presume you want the IF statement in C25 to return the values there
depending on the values in C15. If so, try it this way:

=IF(OR(C15=0,C15=5.5),0,IF(C15<5.5,"x7.5","-x7.5"))

If your "X7.50" is meant to mean multiply C15 by 7.5, then you will
need this instead:

=IF(OR(C15=0,C15=5.5),0,IF(C15<5.5,C15*7.5,-C15*7.5))

Hope this helps.

Pete

On Oct 29, 3:02*pm, Haz wrote:
Hi,

I require an if function that could do the below. I have tried an if
function but can only gat it to work for *the first 2 but not for all.

C15=0 * * * * *C25 =0
C15= 5.50 * *C25=0
C15=<5.50 * C25=X7.50
C15=5.50 * C25=X7.50 * *but show as a minus figure.

Any help would be appreciated.
Thanks
Haz

thanks for the reply, sorry i wasn't clear, but C25 is dependent on what
<5.50 is for example if 5 then a different of .5 which equates to half an
hour and should be 3.75. i have shown this again below hope this helps.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 x7.50 C25=
for example if 5 X7.50 C25=3.75 (7.50/2)
C15=5.50 x7.50 C25= -3.75 but show as a minus figure.
for example if 6 x7.50 C25=-3.75
"John C" wrote:

Not sure what the X7.50 results are supposed to be, so I will leave that up
to you.
C25: =IF(OR(C15=0,C15=5.5),0,IF(C15<5.5,X7.50,-X7.50))
--
** John C **


"Haz" wrote:


Hi,

I require an if function that could do the below. I have tried an if
function but can only gat it to work for the first 2 but not for all.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 C25=X7.50 minus 7.50

C15=5.50 C25=X7.50 but show as a minus figure.

Any help would be appreciated.
Thanks
Haz

I 'think' this may give you the result you are seeking. I am assuming that in
the examples you gave, that the reason both were divided by 2 (or multiplied
by 1/2) is because they were 0.5 off your base of 5.5.
Therefore, try the following formula:
C25: =IF(OR(C15=0,C15=5.5),0,(C15-5.5)*7.5)
--
** John C **


"Haz" wrote:

thanks for the reply, sorry i wasn't clear, but C25 is dependent on what
<5.50 is for example if 5 then a different of .5 which equates to half an
hour and should be 3.75. i have shown this again below hope this helps.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 x7.50 C25=
for example if 5 X7.50 C25=3.75 (7.50/2)
C15=5.50 x7.50 C25= -3.75 but show as a minus figure.
for example if 6 x7.50 C25=-3.75
"John C" wrote:

Not sure what the X7.50 results are supposed to be, so I will leave that up
to you.
C25: =IF(OR(C15=0,C15=5.5),0,IF(C15<5.5,X7.50,-X7.50))
--
** John C **


"Haz" wrote:


Hi,

I require an if function that could do the below. I have tried an if
function but can only gat it to work for the first 2 but not for all.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 C25=X7.50 minus 7.50

C15=5.50 C25=X7.50 but show as a minus figure.

Any help would be appreciated.
Thanks
Haz

Thanks John this is exactly it, however when they are below base of 5.50 i
want a positive result and a negative when above base.

Thanks Again
Haz

"John C" wrote:

I 'think' this may give you the result you are seeking. I am assuming that in
the examples you gave, that the reason both were divided by 2 (or multiplied
by 1/2) is because they were 0.5 off your base of 5.5.
Therefore, try the following formula:
C25: =IF(OR(C15=0,C15=5.5),0,(C15-5.5)*7.5)
--
** John C **


"Haz" wrote:

thanks for the reply, sorry i wasn't clear, but C25 is dependent on what
<5.50 is for example if 5 then a different of .5 which equates to half an
hour and should be 3.75. i have shown this again below hope this helps.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 x7.50 C25=
for example if 5 X7.50 C25=3.75 (7.50/2)
C15=5.50 x7.50 C25= -3.75 but show as a minus figure.
for example if 6 x7.50 C25=-3.75
"John C" wrote:

Not sure what the X7.50 results are supposed to be, so I will leave that up
to you.
C25: =IF(OR(C15=0,C15=5.5),0,IF(C15<5.5,X7.50,-X7.50))
--
** John C **


"Haz" wrote:


Hi,

I require an if function that could do the below. I have tried an if
function but can only gat it to work for the first 2 but not for all.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 C25=X7.50 minus 7.50

C15=5.50 C25=X7.50 but show as a minus figure.

Any help would be appreciated.
Thanks
Haz

Misunderstanding. Just reverse that part of the formula:
Change C15-5.5 to 5.5-C15.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Haz" wrote:

Thanks John this is exactly it, however when they are below base of 5.50 i
want a positive result and a negative when above base.

Thanks Again
Haz

"John C" wrote:

I 'think' this may give you the result you are seeking. I am assuming that in
the examples you gave, that the reason both were divided by 2 (or multiplied
by 1/2) is because they were 0.5 off your base of 5.5.
Therefore, try the following formula:
C25: =IF(OR(C15=0,C15=5.5),0,(C15-5.5)*7.5)
--
** John C **


"Haz" wrote:

thanks for the reply, sorry i wasn't clear, but C25 is dependent on what
<5.50 is for example if 5 then a different of .5 which equates to half an
hour and should be 3.75. i have shown this again below hope this helps.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 x7.50 C25=
for example if 5 X7.50 C25=3.75 (7.50/2)
C15=5.50 x7.50 C25= -3.75 but show as a minus figure.
for example if 6 x7.50 C25=-3.75
"John C" wrote:

Not sure what the X7.50 results are supposed to be, so I will leave that up
to you.
C25: =IF(OR(C15=0,C15=5.5),0,IF(C15<5.5,X7.50,-X7.50))
--
** John C **


"Haz" wrote:


Hi,

I require an if function that could do the below. I have tried an if
function but can only gat it to work for the first 2 but not for all.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 C25=X7.50 minus 7.50

C15=5.50 C25=X7.50 but show as a minus figure.

Any help would be appreciated.
Thanks
Haz

In reality, your formula could be shortened even more, and with no IF
statements.
C25: =(5.5-C15)*7.5*(C150) ... This includes that C15 will never be below 0.
--
** John C **


"Haz" wrote:

Thanks John this is exactly it, however when they are below base of 5.50 i
want a positive result and a negative when above base.

Thanks Again
Haz

"John C" wrote:

I 'think' this may give you the result you are seeking. I am assuming that in
the examples you gave, that the reason both were divided by 2 (or multiplied
by 1/2) is because they were 0.5 off your base of 5.5.
Therefore, try the following formula:
C25: =IF(OR(C15=0,C15=5.5),0,(C15-5.5)*7.5)
--
** John C **


"Haz" wrote:

thanks for the reply, sorry i wasn't clear, but C25 is dependent on what
<5.50 is for example if 5 then a different of .5 which equates to half an
hour and should be 3.75. i have shown this again below hope this helps.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 x7.50 C25=
for example if 5 X7.50 C25=3.75 (7.50/2)
C15=5.50 x7.50 C25= -3.75 but show as a minus figure.
for example if 6 x7.50 C25=-3.75
"John C" wrote:

Not sure what the X7.50 results are supposed to be, so I will leave that up
to you.
C25: =IF(OR(C15=0,C15=5.5),0,IF(C15<5.5,X7.50,-X7.50))
--
** John C **


"Haz" wrote:


Hi,

I require an if function that could do the below. I have tried an if
function but can only gat it to work for the first 2 but not for all.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 C25=X7.50 minus 7.50

C15=5.50 C25=X7.50 but show as a minus figure.

Any help would be appreciated.
Thanks
Haz

Thanks that works perfectly now.

"John C" wrote:

Misunderstanding. Just reverse that part of the formula:
Change C15-5.5 to 5.5-C15.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Haz" wrote:

Thanks John this is exactly it, however when they are below base of 5.50 i
want a positive result and a negative when above base.

Thanks Again
Haz

"John C" wrote:

I 'think' this may give you the result you are seeking. I am assuming that in
the examples you gave, that the reason both were divided by 2 (or multiplied
by 1/2) is because they were 0.5 off your base of 5.5.
Therefore, try the following formula:
C25: =IF(OR(C15=0,C15=5.5),0,(C15-5.5)*7.5)
--
** John C **


"Haz" wrote:

thanks for the reply, sorry i wasn't clear, but C25 is dependent on what
<5.50 is for example if 5 then a different of .5 which equates to half an
hour and should be 3.75. i have shown this again below hope this helps.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 x7.50 C25=
for example if 5 X7.50 C25=3.75 (7.50/2)
C15=5.50 x7.50 C25= -3.75 but show as a minus figure.
for example if 6 x7.50 C25=-3.75
"John C" wrote:

Not sure what the X7.50 results are supposed to be, so I will leave that up
to you.
C25: =IF(OR(C15=0,C15=5.5),0,IF(C15<5.5,X7.50,-X7.50))
--
** John C **


"Haz" wrote:


Hi,

I require an if function that could do the below. I have tried an if
function but can only gat it to work for the first 2 but not for all.

C15=0 C25 =0
C15= 5.50 C25=0
C15=<5.50 C25=X7.50 minus 7.50

C15=5.50 C25=X7.50 but show as a minus figure.

Any help would be appreciated.
Thanks
Haz