=if(g1010,16,if(g105,8,0)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"rvnwdr" wrote in
message ...

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(h105/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?


--
rvnwdr
------------------------------------------------------------------------
rvnwdr's Profile:
http://www.excelforum.com/member.php...o&userid=23903
View this thread: http://www.excelforum.com/showthread...hreadid=381410