Excel Help
Genrail
05 Jun 2011
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&)
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
05 Jun 2011
derp derp 
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.
=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
07 Jun 2011
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
15 Aug 2011
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.
=IF(E5="admin", "-", "numbers go here")
?
What is the purpose of this spreadsheet?
Edited by Rich19, 15 August 2011 - 20:25.
