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