🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Monarch classic : Is there a way to create an If formula to return a blank value

User: "mark_s_vangee"
Altair Community Member

Hello,

I am trying to figure out how to create an If formula to return a blank value.

This is what I'm looking for : If(condition,true value,return a blank value)

My current formula looks like this : If(condition,true value,0) I can't figure out how to return a blank value instead of plugging with a zero (0). It is a numerical field.

I hope that this makes sense.

Thanks,

MVG

p.s. - Happy Holidays to All!

Find more posts tagged with

Sort by:
1 - 2 of 21
    User: "Lasse"
    Altair Community Member

    Hi,

    Could this solve the problem?

    Select Home Options View Suppress zero values

    -Lasse

    User: "mark_s_vangee"
    Altair Community Member
    OP

    Hello,

    Thank You Lasse for trying to help!

    Unfortunately there are times when the value in this field needs to be a zero as it is numerical data.