need help writing a formula!!! : ) Please I need to write a formulathat will subtract .5 (half an ho

[amber12177]

I need to write a formula that will subtract .5 (half an hour) if a time is = to
6 hrs, .75 (45 mins) if time is =to 8 hrs, or 1 (hr) if time is = to 10 hrs.....


I can make it do one or another now....using this formula.....


=IF(A4<6,A4,A4-0.75)


so if G4 is greater than 6(hrs), then it subtracts 45mins.....

but how to I make it do all 3??

=IF(A4 is equal to or falls with in the range of 6 to 7.75 then subtract .5) and ( if A4 is equal to or falls with in the range of 8 to 9.75 then subtract . 75) and if A4 is equal to 10 then subtract 1)but if A4 is less than 6 then it remains A4)



Any ideas or suggestions would be greatly appreciated!!

 

[isabelle]

hi,

=A4-CHOOSE(MATCH(A4,{10;8;6},-1),1,0.75,0.5)

isabelle

Le 2014-07-26 21:47, (e-mail address removed) a écrit :

 

[isabelle]

to forecast errors

=IF(A4<=0,0,IFERROR(A4-CHOOSE(MATCH(A4,{10;8;6},-1),1,0.75,0.5),"out of range"))

isabelle

Le 2014-07-26 22:20, isabelle a écrit :