#1




formula for a cell to equal a value
How to make excel create a formula for a cell to equal a value

#2




Please say more about this. What you're asking is unclear.

#3




example
45 + 11 = 56 45 * 1.244 = 56 and so on 
#4




Okay, so I don't think you're asking how to do those formulas in Excel, are you?
=45+11 =45*1.244 Are you asking why those two formulas might not show the results are equal to each other? The first renders the whole number 56, while the second one results in 55.98. If you want them to be exactly equal, you would use =ROUND(45*1.244,0) to get a result rounded to the nearest whole number, or 56. Do you mean you want the cell to be highlighted if it's equal to a specific value? Like conditional formatting? 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Cell equal value new value of active cell which is a drop down  hassanmoukadem  Excel Programming  1  04132020 07:54 PM 
Conditional formatting formula to format cells not equal to a group value  Marcia  Excel  2  11022019 06:15 AM 
Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu  AlanBird  Excel  3  11252017 03:11 PM 
Automatically change the value of one cell so that two other cells become equal  matthew544  Excel  5  09182011 08:56 AM 
Dividing merge cell into ten equal rectangles for inputing Digit?  aligahk06  Excel  0  05122010 06:56 AM 