Taz O. answered 10/17/21
Experienced MS Excel and SQL Tutor
An alternative way to solve this is to have the 0700, 0730, 0800, 0830 values in the cells A1-A4. The first cell of the second column (B1) should have the formula:
The IF statement checks each cell if any of them contains the number "3". If it does then get cell's value and add 870 to it. If it doesn't then adds 830.
Then you copy the formula in B1 to the other cells (B2-B4) to apply the same formula.
Hope this helps.
Chris S.What do these numbers represent? Are you trying to calculate time intervals? If so, I would format your data as time data type, and use time calculations to do so. If not, please revise your description to include what type of data this is.
Stanton D.Also, it is impossible to determine what your second query is all about. Is "off" a literal text string? If the string is "off 321" what exactly do you wish to display? And how will Excel determine if your entry is in Mandarin? Doesn't Mandarin have numbers, too?