If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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))))) |
#5
|
|||
|
|||
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))))) |
Thread Tools | |
Display Modes | |
|
|