How do I write a formula in Microsoft Works Spreadsheet with a greater than less than value?
I'm trying to build a spreadsheet that tracks my monthly hours and wages. (I get paid by the month) I have everything but the Federal Withholding figured. If my wages are below a certain amount my tax is 0%, if at or above that amount they are 10%. How do I write a formula for that?
- IXL@XLLv 78 years agoFavorite Answer
=IF(cell_holding_earnings < a_figure,0, cell_holding_earnings * 10%)