Does anyone know where I can find a list of all the acceptable excel formula functions with a description of what they do? (if, than, true, false....)
I am trying to have a blank cell base on another cell being false.
=IF(G4,(C4),(???))
if G4 is true the cell will =C4
if G4 is false the cell should be left blank
Hi Kevin,
For a function list, see here (Excel 2007): http://office.microsoft.com/en-us/ex...791861033.aspx
As for your other issue, try:
=IF(G4,C4,"")
You don't need G4=TRUE, since the value in G4 will provide the TRUE or FALSE result of the test.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks