Hello Gurus ,
I have a scenario in excel , where I have three cells
Cell 1 is the Qty
Cell 2 is the unit price
Cell 3 is the total price
there is formula added Cell 3 = Cell 2 * Cell 1
Now I don't want to show the value of Cell 1 and needs to mention as " LS" .
Question is : how can I change the particar cell ( in this case , Cell 1) to "LS" , without affecting the formulae of calculation