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

[fei]

what does it mean?

[mangesh_yadav]

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]

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

[FLKULCHAR]

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

"fei" wrote:

> what does it mean?

[Bill Martin -- (Remove NOSPAM from address)]

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