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