sales for hours

[msiu]

i need formula to convert for every 1000 dollar sales 38 hours of work

 

[kpark91]

=Mod(A1,1000) * 38

where A1 is the dollars.

 

[msiu]

thank you........i tired formula but gives me a total of 0???
calculation need to be for evevy $1000 dollars will equal 38 hours and for anything over 100 dollars add one hour

 

[kpark91]

Try

=MOD(A1, 1000) * 38 + IF(A1 >= 100, 1, 0)

 

[msiu]

Thank you.............but Arrrrrrrrrgh it didnt work.......

 

[kpark91]

?? I'm not sure what you're looking for.

Could you elaborate on your problem and what you need in FULL details?
and provide an example whether it be a table of fake data.

 

[Ingolf]

Hi,

Try this: =INT(A1/1000)*38+MOD(A1;1000)/100

Where A1 is the dollars.

 

[Ingolf]

Hi,

More accurate... =ROUNDUP(INT(A1/1000)*38+(MOD(A1;1000)/100)

Where A1 is the dollars.