Cherry has attended:
Excel Intermediate course
Excel Advanced course
Excel numerical value in a cell
Hi,
Please could you help with the following enquiry? Is there any way of adding a numerical integer into a cell that already contains a different number. For example in A1, it shows 12, A2 shows 12, A3 shows 8 can you make each cell mean 10 so that when you use the formula =sum(a1+a2+a3) it adds up to 30?
Many thanks
Cherry
RE: Excel numerical value in a cell
Hi Cherry, thanks for your query. There is no standard function in Excel to allow you to do this and to achieve it would involve some bespoke VBA. However, depending on what you want to achieve, have you thought about have 10 as the value in A3 and then drawing a white-filled rectangle over the cell with the number 8 in it, obscuring the real value but leaving it intact for use in formulae? The end result, visually at least, would be the same as your request.
Hope this helps,
Anthony
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
