expert with formulas needed again

  • Thread starter Thread starter rvnwdr
  • Start date Start date
R

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?
 
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
 
I have tried both of these formulas and my spreadsheet keeps giving me
0:00 if it is over 5 hrs... :)
 
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
 
Back
Top