200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Please i want a formula that can be applied on gross income to determine taxable income and at the same time return the result to the gross income if the taxable income will be less than 300,000.
Taxable income = gross income minus (20% of gross income + 200,000)
My expectation: If the result is less than 300,000 , then let the result be returned to the gross income value and coloured red.
Kindly assist Asap.
Try,
=if(GI-(0.2*GI+200000)<300000, GI, GI-(0.2*+200000))
As for the colour, you will need to apply conditional formatting for the cell.
