expert with formulas needed again

[rvnwdr]

I currently have this formula entered to calculate the meal allowance of
$8.00 if a value in another cell is over 5 hrs and 0 or blank if it is
under this.
=if(g10=f10,"",if(h10>5/24,8,0))

I would like to go one more step. I would like it to calculate the
$8.00 if over 5 hrs, 0 or blank if under or blank hrs and $16.00 if it
is over 10 hrs. Can any one help me?

 

[Anne Troy]

=if(g10>10,16,if(g10>5,8,0)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[dominicb]

Good evening rvnwdr

I have inserted one extra IF statement to cater for the $16 allowance
and in the tests I've just done it seems to work OK - is this OK for
you?

=IF(G10=F10,"",IF(H10>10,16,IF(H10>5,8,0)))

HTH

DominicB

 

[rvnwdr]

I have tried both of these formulas and my spreadsheet keeps giving me
0:00 if it is over 5 hrs...

 

[mangesh_yadav]

The same formula but you need to take care of the time format, and so
while checking divide by 24:

=IF(G10=F10,"",IF(H10>10/24,16,IF(H10/24>5,8,0)))

Mangesh