If A calculation is less than X return zero

[p911pew]

Hi Folks

I was wondering if anyone can help me.

I am looking a calculation that returns a figure only if it is greater than 250

so for instance

(A1/100)*7<250 then return "0"

THe calculation is slightly more complex than this however for example purposes.

Thanks
Tom

[Lemice]

Hello,

You can put it in an IF, like this

Please Login or Register  to view this content.