Suppose you enter the above formula in cell C17, then it checks the
value in cell C16. If it is empty (i.e. "") then it puts the value in
C16 (which is blank) in C17. But if C16 is not blank, then it puts 0.4
in cell C17.
Suppose you enter the above formula in cell C17, then it checks the
value in cell C16. If it is not empty (i.e. <> "") then it puts the
value of C16 in C17. But if C16 is blank, then it puts 0.4 in cell
C17.
The other guys have answered the specific question you actually asked.
However in answer to the question you *didn't* ask, within Excel click
on "Help" at the top then on "Contents and Index". Type "IF" into the
search window and it will bring up a lot of helpful information on the
IF() function -- complete with examples of how to use it.
Excel has a good set of help information for all of it's functions and
it's generally a great place to start and a good learning tool.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
