Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2023, 06:11 PM
kunve kunve is offline formula for a cell to equal a value Windows 11 formula for a cell to equal a value Office 2019
Novice
formula for a cell to equal a value
 
Join Date: Mar 2023
Posts: 2
kunve is on a distinguished road
Default formula for a cell to equal a value


How to make excel create a formula for a cell to equal a value
Reply With Quote
  #2  
Old 03-27-2023, 01:52 PM
kilroyscarnival kilroyscarnival is offline formula for a cell to equal a value Windows 10 formula for a cell to equal a value Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by kunve View Post
How to make excel create a formula for a cell to equal a value
Please say more about this. What you're asking is unclear.
Reply With Quote
  #3  
Old 03-28-2023, 02:04 AM
kunve kunve is offline formula for a cell to equal a value Windows 11 formula for a cell to equal a value Office 2019
Novice
formula for a cell to equal a value
 
Join Date: Mar 2023
Posts: 2
kunve is on a distinguished road
Default

example
45 + 11 = 56
45 * 1.244 = 56
and so on
Reply With Quote
  #4  
Old 03-28-2023, 05:36 AM
kilroyscarnival kilroyscarnival is offline formula for a cell to equal a value Windows 10 formula for a cell to equal a value Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by kunve View Post
example
45 + 11 = 56
45 * 1.244 = 56
and so on
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?
Reply With Quote
Reply

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 04-13-2020 07:54 PM
formula for a cell to equal a value Conditional formatting formula to format cells not equal to a group value Marcia Excel 2 11-02-2019 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 11-25-2017 03:11 PM
Automatically change the value of one cell so that two other cells become equal matthew544 Excel 5 09-18-2011 08:56 AM
Dividing merge cell into ten equal rectangles for inputing Digit? aligahk06 Excel 0 05-12-2010 06:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft