I am needing to multiply E5 by 4, then if N44 is <150 I need to divide E5 by 3.33, if N44 is less than 300 I need to divide by 2.50 and if it is more then 300 I then need to divide by 1.66. This formula will go into J66 and I need the results to appear as X Hours.
Is it possible to do this I have played about a little but this is beyond my knowledge. Thanks.
Hi Carolan,
You sure, can, for example:
=IF(N44<150,E5/3.33,IF(N44<300,E5/2.5,E5/1.66)
This says:
IF N44 is less than 150 then divide E5 by 3.33, otherwise IF N44 is less than 300 then divide E5 by 2.5, otherwise IF N44 does not fit into the previous values (any # greater than or equal to 300) then divide E5 by 1.66.
You can then format J66 to appear as hours.
That works perfect if I do the multiply sum for E5 into cell P1, I am trying to add the word HOURS on the end not am/pm (sorry my fault should have said) in the format cell section I can't see a way to add anything to the end.
Thank you for the formula though...I did get close just not close enough he he he
To add "hours" at the end, you could try:
=IF(N44<150,E5/3.33&" hours",IF(N44<300,E5/2.5&" hours",E5/1.66&" hours")
Paul, why not make it simpler
=IF(N44<150,E5/3.33,IF(N44<300,E5/2.5,E5/1.66))&" hours"
I need your support to add reputations if my solution works.
These both work but the formatting applied to the cell (to get rid of all decimals) doesn't work with Hour in the cell. I think I will look at putting it in cell next to it or something. Thanks to you both
The '&' is making the value into a text. I do not prefere that as you might want to use the value somewhere else. Therefore use cell format.
Format Cells, Custom, 0 " hours"
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
That one worked perfect thanks you.
carolan, Do noy give up that easily. We don't ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks