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
|