formula help

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
 
J

Jeff Brown

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

Jeff Brown

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

Jacob Skaria

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding cells but leaving blank if not populated 1
need to subtract .50 from a cell if it is over 6.00 4
conditional formatting help required. 2
Code help 0
IF Statement (AND/OR) 2
Is there an Excel Function that can be used in lieu of this formul 5
How do I get an IS and IF statement to work together in excel? 3
data from 1 sheet to the next 6

Top