View Single Post
 
Old 05-25-2017, 05:36 PM
riothecat riothecat is offline Windows 10 Office 2007
Novice
 
Join Date: Nov 2016
Posts: 27
riothecat is on a distinguished road
Default multiple if functions in 1 cell

the following is what I need but cannot get close to what I need to do. Any help is appreciated...

In cell a2 IF A1 >0 BUT < 96 THEN A3
OR IF A1 > 96.01 but< 192 THEN A4
OR IF A1>192 but < 288THEN A5
OR IF A1>288 but < 384 THEN A6
OR IF A1>384 but <769 THEN A7
basically it is a tax withholding formula for my business.
to appear in a2


Thank In Advance
Reply With Quote