How would I go about writing a formula if I wanted to say "if any of the values in cells A1, A2, or A3 are greater than 22, subtract that difference from the number already in A4 (which is 35)
My help desk is no help!
Sorry, but if A4 has a value in it, you're not going to be able to influence that value with a formula in another cell. If that's what you're after, you're going to need visual basic, and I think that might be overkill.
Maybe you could put the formula in A5 and hide row 4, then row 5 will print/appear on screen in row 4's place
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.