# how do I enter this nested IF function?

October 31, 2010 at 13:21:36
Specs: Windows 7
 if cell F43 is less than \$150 then it should put 12.75 in the cell, but if the cell is more than \$150 then it should multiply the amount in the cell X 8.75%, but if the cell f43 has a \$0 amount then it should put 0 in cell f43

See More: how do I enter this nested IF function?

#1
October 31, 2010 at 14:46:08
 Your question doesn't make any sense.re: "if cell F43 is less than \$150 then it should put 12.75 in the cell"In what cell should the 12.75 be put?re: "but if the cell is more than \$150 then it should multiply the amount in the cell X 8.75%"Again: What cell?re: "but if the cell f43 has a \$0 amount then it should put 0 in cell f43"If F43 has \$0 in it, then why would you need a formula to put \$0 in it? F43 already has \$0 in it.You need to be more specific regarding what cell has a value in it and what cell should have the formula.You can't enter values in cell that contains a formula.

Report •
Related Solutions