Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MS Excel 'IF' function
Goska... Good news, I added the 8th 'IF' statement - IF(P27>=18333333,((P27-18333333)*0.35)+6416667) - for taxable income of $18,333,333 and greater - and it's working. Again, awesome! However, this 'IF' statement - IF(I25<=150000,"40,000.00...- jevans
- Post #9
- Forum: Microsoft: Office
-
MS Excel 'IF' function
Goska...AWESOME, many thanks. Your revised version works...smack-on! However, now I need to ask how do I add an 8th 'IF' statement to the same cell for taxable income of $18,333,333 or greater? Assuming the following - IF(P27>=18333333,((P27-18333333)*0.35)+6416667) - to be a correct 'IF'...- jevans
- Post #8
- Forum: Microsoft: Office
-
MS Excel 'IF' function
GOSKA - how should I have 'line wrapped' my original post? Now I'm off to try your second suggestion. jevans- jevans
- Post #5
- Forum: Microsoft: Office
-
MS Excel 'IF' function
GOSKA - making the change you suggested, the answer comes back 'FALSE'. A number, 'the resulting tax amount should be coming back. jevans- jevans
- Post #4
- Forum: Microsoft: Office
-
MS Excel 'IF' function
I'm trying to set-up and 'IF' formula to calculate a tax based on a IRS corporate tax schedule that must incle all of the applicable tax rates To do so, I've built the following 'IF' statement but I can't get it to calculate the tax properly...- jevans
- Thread
- Replies: 8
- Forum: Microsoft: Office
