Showing related tags and posts accross the entire site.
-
=IF((AND(L16="H",H16>0)),(J16-H16+K16),IF((OR(L16="H",H16=0)),(H16+J16+K16),(IF(L16="D",(I16+DATE_TEXT(K16)),IF(L16="C",(H16+J16+K16)))))) When the user selects "d" in L16, the system needs to add a date such as 4/24/2007 in cell I16 and a number of...
-
You could use a Worksheet_Change() event. The one below will take a text string in A1 and convert the format in B1 to whatever is set in A1 (There is no Case Else statement, so currently it must be one in the list, this can be expanded though) To place this, right click on the relevant sheet tab and...
-
I've created a spreedsheet that allows a users to choose a currency (Euro, US$, Aust$ etc) from a drop down list. This applies an exchange rate factor to a set of cells in the spreadsheet for a bunch of product prices. I would like the cells with the prices to use the correct currency format of the...