3 replies to this topic

[Genrail]

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&)

[Wizard]

derp derp

=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.

[Genrail]

 Wizard, 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.

[Rich19]

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.