google spreadsheet - Two format number in a same cell -


could tell me, if possible have 2 number format in 1 cell? number format change depending on result of cell.

i attach link my test file

have @ text() object's document: https://support.google.com/docs/answer/3094139?visit_id=1-636271325324199875-441828486&hl=en-gb&rd=1


added solution spreadsheet in cell h5:

=if(b11="x";text(c11;"0.00 €");text(c11;"hh:mm:ss"))


each text's 2nd argument updatable, i.e. have either: "0.00 €" or "€ 0.00" or "hh:mm" etc.


Comments