This is my first post on the forum so please bear with me. I'm trying to use an IF command in excel but my excel knowledge peaked a few years ago when I got to pivot tables as I never really needed to use IF, VLOOKUPS or Macros.
The attached spreadsheet is an income tax calculation. What I want to do is insert a formula in cell A12 that IF F9 is greater than or equal to 36,400 then A12=36,400 however if F9 is less than 36,400 then A12 is equal to F9.
I hope that makes sense, any replies are appreciated.
Bookmarks