Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
MS Excel help with IF THEN statments?
I am creating a budget spreadsheet for work where we get paid commissions. When a comb box is selected from 'unpaid' to 'paid' I want the commission amount in one cell to be deducted from the overall amount that is due displayed in another cell. Can anyone help with the code, I am assuming its VB code that I need to write. Amy help would be much appriciated.
Thanks
OK, so what are the formulas?
2 Answers
- 1 decade agoFavorite Answer
combo boxes have cell links, those cell links will contain a value which is normally numerical, this figure corresponds to a particular piece of data in the list. Basically find the cell link (right click on the combo box, you can change it if you want) and construct an if statement with the criteria IF("combo box cell link" = "a particular value", "insert formula to deduct whatever the relevant cell references are" , " insert the false condition")
hope that helps !
- The Drunken FoolLv 71 decade ago
you should be able to do that with formulas, no need to messy coding....
