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