how do i write a formula for this (this is what i have in m3 as my formula)
=(l3*35)*2
now how do i have it if the return to this is say 50 and in cell c3 is 90.
Since the formula is less than or equal to 90 i want the return to be 0

I hope i explained this clear enough

here is a sample of what i have in my spread sheet
Avg time2008(e31) -Time taking wk of10/3/08(J31) - Diff in week(k31)-Convert
to time(l31)-Total $(m31)
48.47 min - 56 min - 7.53
min - .01255 - $8.79

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1

try this

=IF((l3*35*2<=C3), "0", l3*35*2)




"Darts via OfficeKB.com" wrote:

how do i write a formula for this (this is what i have in m3 as my formula)
=(l3*35)*2
now how do i have it if the return to this is say 50 and in cell c3 is 90.
Since the formula is less than or equal to 90 i want the return to be 0

I hope i explained this clear enough

here is a sample of what i have in my spread sheet
Avg time2008(e31) -Time taking wk of10/3/08(J31) - Diff in week(k31)-Convert
to time(l31)-Total $(m31)
48.47 min - 56 min - 7.53
min - .01255 - $8.79

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1

Raz wrote:
try this

=IF((l3*35*2<=C3), "0", l3*35*2)

how do i write a formula for this (this is what i have in m3 as my formula)
=(l3*35)*2
[quoted text clipped - 8 lines]
48.47 min - 56 min - 7.53
min - .01255 - $8.79

Thank You it worked great!! Your the best!!

--
Message posted via http://www.officekb.com

Hi,

Let's simplify this down a bit:

=IF(L3*70<C3,0,L3*70)

35*2 is a constant so just enter 70. There is not need to "0", technically
that is a text entry not a number, besides it waste keystrokes. You don't
need () around the if test. Might as well get into good formula construction
habits early.
--
Thanks,
Shane Devenshire


"Darts via OfficeKB.com" wrote:

Raz wrote:
try this

=IF((l3*35*2<=C3), "0", l3*35*2)

how do i write a formula for this (this is what i have in m3 as my formula)
=(l3*35)*2
[quoted text clipped - 8 lines]
48.47 min - 56 min - 7.53
min - .01255 - $8.79

Thank You it worked great!! Your the best!!

--
Message posted via http://www.officekb.com