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 92262 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
  • 409 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,215 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
------------------------------------------------------------

mvplogo1_zpsea7gtc7e.gif



WTT-Grad1.jpg

Topics are closed after 5 days without response
unite_blue_zpsbfd3cd98.png

#3 scudo

scudo

    Silver Member

  • Authentic Member
  • PipPipPip
  • 409 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,215 posts

Posted 31 May 2015 - 03:35 PM

:thumbup:


Tomk
------------------------------------------------------------

mvplogo1_zpsea7gtc7e.gif



WTT-Grad1.jpg

Topics are closed after 5 days without response
unite_blue_zpsbfd3cd98.png

Related Topics



0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users