Conditional Formatting?

Post Reply
cmcdar
Posts: 4
Joined: Sat Apr 20, 2019 12:50 pm

Conditional Formatting?

Post by 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
SoftMaker Team
SoftMaker Team
Posts: 1233
Joined: Wed Jun 05, 2019 12:02 pm

Re: Conditional Formatting?

Post by miguel-c »

=IF(NOT(ISBLANK(C7)),D7-39,"")
or
=IF(NOT(ISBLANK(C7));D7-39;"")
cmcdar
Posts: 4
Joined: Sat Apr 20, 2019 12:50 pm

Re: Conditional Formatting?

Post by cmcdar »

Awesome!!!!


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

8)
Post Reply

Return to “PlanMaker 2018 for Windows”