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

=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

"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.

"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)))))

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)))))