formula help
I have a formula and can not make it work the way I would like.
=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24)))) here it is. I need it to subtract .50 from I5 if I5 is greater then 6.00 |
formula help
=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(IF(I56,I5-0.5,I5)/24)))
-- Regards Dave Hawley www.ozgrid.com "Jeff Brown" <Jeff wrote in message ... I have a formula and can not make it work the way I would like. =IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24)))) here it is. I need it to subtract .50 from I5 if I5 is greater then 6.00 |
formula help
"ozgrid.com" wrote: =IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(IF(I56,I5-0.5,I5)/24))) -- Regards Dave Hawley www.ozgrid.com "Jeff Brown" <Jeff wrote in message ... I have a formula and can not make it work the way I would like. =IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24)))) here it is. I need it to subtract .50 from I5 if I5 is greater then 6.00 That would work I think but every time I do something like that it stops displaying the result in the cell I5 it is just blank. |
formula help
"Jeff Brown" wrote: "ozgrid.com" wrote: =IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(IF(I56,I5-0.5,I5)/24))) -- Regards Dave Hawley www.ozgrid.com "Jeff Brown" <Jeff wrote in message ... I have a formula and can not make it work the way I would like. =IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24)))) here it is. I need it to subtract .50 from I5 if I5 is greater then 6.00 That would work I think but every time I do something like that it stops displaying the result in the cell I5 it is just blank. ok I fixed the blank part it helps if you have the right cell numbers, but it still does not subtract .50 from the total. here is the formula with the right cell numbers =IF(H6="P",G6+12-F6,IF(H6="A",G6-F6,(IF(I66,I6-0.5,(I6/24))))) |
formula help
Jeff
Your initial post says "I need it to subtract .50 from I5 " and thats what the formula (posted by Dave) does now.. Instead do you want to deduct .5 from the total (as mentioned in the last post)? -- Jacob (MVP - Excel) "Jeff Brown" wrote: "Jeff Brown" wrote: "ozgrid.com" wrote: =IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(IF(I56,I5-0.5,I5)/24))) -- Regards Dave Hawley www.ozgrid.com "Jeff Brown" <Jeff wrote in message ... I have a formula and can not make it work the way I would like. =IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24)))) here it is. I need it to subtract .50 from I5 if I5 is greater then 6.00 That would work I think but every time I do something like that it stops displaying the result in the cell I5 it is just blank. ok I fixed the blank part it helps if you have the right cell numbers, but it still does not subtract .50 from the total. here is the formula with the right cell numbers =IF(H6="P",G6+12-F6,IF(H6="A",G6-F6,(IF(I66,I6-0.5,(I6/24))))) |
All times are GMT +1. The time now is 04:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com