SoftMaker.com

Awesome!!!!


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

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,

WOW - that was simple!!!

Thank you so much

Hello,

I would like to have a negative number appear in RED text.

I have found that I can use conditional formatting to change the cell shading but have not found a way to conditionally format text color.

Is there any way to do this?

Thank you!