Microsoft Office Forums formula for a cell to equal a value
 Register FAQ Search Today's Posts Mark Forums Read

#1
03-25-2023, 06:11 PM
 kunve Windows 11 Office 2019 Novice Join Date: Mar 2023 Posts: 2
formula for a cell to equal a value

How to make excel create a formula for a cell to equal a value
#2
03-27-2023, 01:52 PM
 kilroyscarnival Windows 10 Office 2021 Expert Join Date: May 2019 Posts: 268

Quote:
 Originally Posted by kunve How to make excel create a formula for a cell to equal a value
#3
03-28-2023, 02:04 AM
 kunve Windows 11 Office 2019 Novice Join Date: Mar 2023 Posts: 2

example
45 + 11 = 56
45 * 1.244 = 56
and so on
#4
03-28-2023, 05:36 AM
 kilroyscarnival Windows 10 Office 2021 Expert Join Date: May 2019 Posts: 268

Quote:
 Originally Posted by kunve 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?

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post hassanmoukadem Excel Programming 1 04-13-2020 07:54 PM Marcia Excel 2 11-02-2019 06:15 AM AlanBird Excel 3 11-25-2017 03:11 PM matthew544 Excel 5 09-18-2011 08:56 AM aligahk06 Excel 0 05-12-2010 06:56 AM

Other Forums: Access Forums

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

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top