software

I'm trying to teach myself EXCEL by working through problems in a workbook.
Unfortunately I've hit a wall with the following problem:

I have the following values : Social Security Tax Withheld YTD, current
Gross pay, Social Security tax rate of .062. The worksheet I'm working
assigns column G for current social security tax, I'm given the information
that the maximum Social Security Tax Withheld YTD should not exceed a manimum
value of 5394 but I haven't been able to figure out the formula for this.
So far I have =IF(E4 (F4*0.062)lt;=5394,F4*0.062,quot;F4*.062 not to exceed 5394quot;)
but don't know how to insert the value for the quot;not to exceedquot;
Thanks for any help offered!Perhaps: =IF(E4 (F4*0.062)lt;5394,F4*0.062,5394)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;lja57quot; gt; wrote in message
...
gt; I'm trying to teach myself EXCEL by working through problems in a
workbook.
gt; Unfortunately I've hit a wall with the following problem:
gt;
gt; I have the following values : Social Security Tax Withheld YTD, current
gt; Gross pay, Social Security tax rate of .062. The worksheet I'm working
gt; assigns column G for current social security tax, I'm given the
information
gt; that the maximum Social Security Tax Withheld YTD should not exceed a
manimum
gt; value of 5394 but I haven't been able to figure out the formula for this.
gt; So far I have =IF(E4 (F4*0.062)lt;=5394,F4*0.062,quot;F4*.062 not to exceed
5394quot;)
gt; but don't know how to insert the value for the quot;not to exceedquot;
gt; Thanks for any help offered!
gt;
gt;
gt;
gt;
Hi=MIN(5394,TaxFormula)Arvi Laanemetsquot;lja57quot; gt; wrote in message
...
gt; I'm trying to teach myself EXCEL by working through problems in a
workbook.
gt; Unfortunately I've hit a wall with the following problem:
gt;
gt; I have the following values : Social Security Tax Withheld YTD, current
gt; Gross pay, Social Security tax rate of .062. The worksheet I'm working
gt; assigns column G for current social security tax, I'm given the
information
gt; that the maximum Social Security Tax Withheld YTD should not exceed a
manimum
gt; value of 5394 but I haven't been able to figure out the formula for this.
gt; So far I have =IF(E4 (F4*0.062)lt;=5394,F4*0.062,quot;F4*.062 not to exceed
5394quot;)
gt; but don't know how to insert the value for the quot;not to exceedquot;
gt; Thanks for any help offered!
gt;
gt;
gt;
gt;