Conditional Formatting?

[cmcdar]

Hi,

How do you get a function to perform only if one field is not blank?
C7 (saturday miles)
D7 (weeks total miles)
F7 (function)

What I want is if C7(saturdays miles) is not blank,(only) then perform the function =D7-39. Else the field remains blank or at 0.00.

Thank you,

[miguel-c]

=IF(NOT(ISBLANK(C7)),D7-39,"")
or
=IF(NOT(ISBLANK(C7));D7-39;"")

[cmcdar]

Awesome!!!!


=IF(NOT(ISBLANK(C7)),D7-39,"") WORKED - Thanks so much!