Oct 31 2023 06:52 AM
How do i ensure that the cell containing the randbetween function in E15 remain static and do not update when new values are entered elsewhere in the spreadsheet in Excel but only chnages when the column F15 is edited.
I have this function ="Quotation#: "&" "&UPPER(LEFT($F$15,5))&"-"&UNIQUE(RANDBETWEEN(185,1000))&"-"&TEXT(F10,"23") but it updates whenever i enter something in another cell.
Oct 31 2023 07:41 AM