I need to write an IF function using the following logic to determine the social Security tax for cell G4.

If Soc. Sec. Tax * Gross Pay + YTD Soc.

sec. > Maximum Soc. Sec., then Maximum

Soc. Sec. _ YTD soc. Sec., otherwise Soc.

Sec. Tax* Gross Pay.

F4 is gross pay

E4 is YTD

G4 is Soc. Sec

I am not sure how to put this in an IF function because of Maximum Soc. Sec.,

Can someone show me how to write this.?

I started it like this:

=IF (G4* F4 + E4)> now what do I put?

HELP going nuts here.

Another one is.

Medicare = Medicare Tax * Gross Pay

H4 medicare

F4 gross pay

E4 YTD soc.sec.

third one is:

=Gross pay- (soc.Sec. + Medicare + fed. Tax + State tax)

F4 gross pay

G4 soc. sec.

H4 medicare

I4 Fed Tax

J4 state tax

need this in IF function entered in K4

I know this is a lot to ask but hope this will finish this problem I am working on now. Thanks if anyone can help

Cleta