If function multiple Criteria
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
|