formula help

  • Thread starter Thread starter Jeff Brown
  • Start date Start date
J

Jeff Brown

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 said:
=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(IF(I5>6,I5-0.5,I5)/24)))
Click to expand...
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 said:
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.
Click to expand...


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(I6>6,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)?
 
Back
Top