IfSum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TYE - 27 Aug 2005 16:15 GMT

i would like 2 do the following,

if an person as done less then 36 hours all their bouns from 5 will go down
to 0.50

=<36hours (bonus/5), this times 0.50

like a sum that works this out

e.g

Ian Smith did 34 hours got 10 sales @ 5 total = 50 so i need a sum that will
change this so it say 5 not 50

Reply to this Message

BenjieLop - 27 Aug 2005 17:48 GMT

TYE Wrote:

> i would like 2 do the following,
>
[quoted text clipped - 11 lines]
> will
> change this so it say 5 not 50

It appears that your example (last sentence) is not consistent with
your premise. Anyway, I am suggesting a solution based on how I
interpret your last sentence. Based on this, your IF statement would
look something like this:

IF[/B] (HOURS_WORKED<36) *THEN* (BONUS=5)* ELSE * (BONUS=SALES*5)

AND SO, YOUR FORMULA SHOULD BE

[B]=IF(B1<36,5,C1*5)

where

B1 contains the number of hours worked and
C1 contains the sales

.. hope this is what you need.

Regards.

Signature

BenjieLop

Reply to this Message

Ian - 27 Aug 2005 18:01 GMT

=IF(hours=<36,bonus*0.5,bonus*5)

Replace hours and bonus with the relevant cell references

Signature

Ian
--

>i would like 2 do the following,
>
[quoted text clipped - 11 lines]
> will
> change this so it say 5 not 50

Reply to this Message

Bob Phillips - 27 Aug 2005 18:02 GMT

=IF(total_hours<36,sales*.5,sales*5)

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

> i would like 2 do the following,
>
[quoted text clipped - 9 lines]
> Ian Smith did 34 hours got 10 sales @ 5 total = 50 so i need a sum that will
> change this so it say 5 not 50

Reply to this Message