@if on lotus5

[Cottongin]

spread sheet for a cotton gin calculates the number of
bales I have to gin and how long it will take me.
M6 contains the estimated bales per load
O6 contains the actual bales per load
P6 @sum(o6-p6) difference in estimated and actual
If there is nothing in o6 yes, p6 returns value of m6
how can I make p6 return "notginned"

 

[DaleWatson123321]

I believe the formula you're seeking is...

@IF(O6=0,"notginned",O6-M6)

Hope this helps. Please advise as to how it fits.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[Cottongin]

Thanks, Dale it works perfectly. I knew I would get an
answer from you - like you, I think 123r5W is the
only spreadsheet program
Celeta Moses