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,
Conditional Formatting?
Re: Conditional Formatting?
=IF(NOT(ISBLANK(C7)),D7-39,"")
or
=IF(NOT(ISBLANK(C7));D7-39;"")
or
=IF(NOT(ISBLANK(C7));D7-39;"")
Re: Conditional Formatting?
Awesome!!!!
=IF(NOT(ISBLANK(C7)),D7-39,"") WORKED - Thanks so much!
=IF(NOT(ISBLANK(C7)),D7-39,"") WORKED - Thanks so much!