Jump to content

Build Theme!
  •  
  • Infected?

WE'RE SURE THAT YOU'LL LOVE US!

Hey there! :wub: Looks like you're enjoying the discussion, but you're not signed up for an account. When you create an account, we remember exactly what you've read, so you always come right back where you left off. You also get notifications, here and via email, whenever new posts are made. You can like posts to share the love. :D Join 92410 other members! Anybody can ask, anybody can answer. Consistently helpful members may be invited to become staff. Here's how it works. Virus cleanup? Start here -> Malware Removal Forum.

Try What the Tech -- It's free!


Photo

Help with formula change


Best Answer Tomk , 31 May 2015 - 03:18 PM

Looks right to me. If you delete the equals sign (=) the formula would show in the cell as text - but of course there would be no equals sign showing. Other than that, the only way I know how to show the formula in the cell - complete with eq... Go to the full post


  • Please log in to reply
3 replies to this topic

#1 scudo

scudo

    Silver Member

  • Authentic Member
  • PipPipPip
  • 430 posts

Posted 31 May 2015 - 01:59 PM

I have this formula in a cell    = COUNTIF(May!$E:$E,"o")     when I attempt to change the "o" to "a" the formula displays in the cell as an actual formula

 

=COUNTIF(May!$E:$E,"a")    displays in the cell  but does not work.

 

Hope I make sense.


    Advertisements

Register to Remove


#2 Tomk

Tomk

    Beguilement Monitor

  • Classroom Admin
  • 20,256 posts

Posted 31 May 2015 - 03:18 PM   Best Answer

Looks right to me.

 

If you delete the equals sign (=) the formula would show in the cell as text - but of course there would be no equals sign showing.

 

Other than that, the only way I know how to show the formula in the cell - complete with equals sign -  is to hold control and accent key (`).  Formula would then continue to show until you click in the cell and hit Ctrl ` again.


Tomk
------------------------------------------------------------
Microsoft MVP 2010-2014
Topics are closed after 5 days without response
 


#3 scudo

scudo

    Silver Member

  • Authentic Member
  • PipPipPip
  • 430 posts

Posted 31 May 2015 - 03:25 PM

As it turned out it was the cell format, I changed to general and that allowed the change.



#4 Tomk

Tomk

    Beguilement Monitor

  • Classroom Admin
  • 20,256 posts

Posted 31 May 2015 - 03:35 PM

:thumbup:


Tomk
------------------------------------------------------------
Microsoft MVP 2010-2014
Topics are closed after 5 days without response
 

Related Topics



0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users