=IF(C16<>"",C16,0.4)
 

what does it mean?

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.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=377980

Sorry, it is the other way round.

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.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=377980

it means, if c16 is blank...enter 0.4...otherwise, if c16 is NOT blank, enter
its value.

"fei" wrote:

what does it mean?

fei wrote:
what does it mean?
---------

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.

Good luck...

Bill