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?

1 Answer

  • IXL@XL
    Lv 7
    8 years ago
    Favorite Answer

    =IF(cell_holding_earnings < a_figure,0, cell_holding_earnings * 10%)

Still have questions? Get your answers by asking now.