excel formula suggestion

November 27, 2010 at 12:20:38
Specs: Windows XP
which calculates the amount due to the employee if the total expenses exceed the cash advance. Display a "0" in the cell if the expenses do not exceed the cash advance.

K:38 total expenses =3281.60 =SUM(K25,K30:K36)
K:39 blank
K:40 less cash advance = 1000.00
K:41 amount due employee = 2281.6
K:42 amount due company = 0.00 =IF(K38>K40,0)

See More: excel formula suggestion

Report •


#1
November 27, 2010 at 15:11:57

Report •

#2
November 27, 2010 at 16:19:20
Lousy grammar?

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •

Related Solutions


Ask Question