Jump to content


Excel Help


3 replies to this topic

#1 Genrail

    Semi-Pro

  • Project Team
  • 234 posts
  • Projects: Private Map Contractor

Posted 05 June 2011 - 01:22

I mainly need a IF statement to work in the background and display in a specific cell if it is true.

I’m using Excel 2010! Thanks in advance!


EX: =IF(E5="Admin","-", &This is where i need help, I can't have a false statement because i need to edit the cell with a number&)
This place still exists?

#2 Wizard

    [...beep...]

  • Administrator
  • 9627 posts

Posted 05 June 2011 - 07:42

derp derp :beer:

=IF(E5="admin", "-", "")


Would show a blank cell if E5 was empty and - if admin was written. What I don't get is why you can't have a false statement???

Edited by Wizard, 05 June 2011 - 07:45.


#3 Genrail

    Semi-Pro

  • Project Team
  • 234 posts
  • Projects: Private Map Contractor

Posted 07 June 2011 - 00:15

View PostWizard, on 5 Jun 2011, 2:42, said:

What I don't get is why you can't have a false statement???



I need to freely edit the cell. Numbers will be entered in the cell where the IF statement is.
This place still exists?

#4 Rich19

    I challenge thee!

  • Member
  • 1478 posts
  • Projects: Duelling

Posted 15 August 2011 - 20:25

Why can't you simply have:

=IF(E5="admin", "-", "numbers go here")

?

What is the purpose of this spreadsheet?

Edited by Rich19, 15 August 2011 - 20:25.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users