IFS Error

[mtaylor]

This is a follow-up thread to an original question posted here:

If column E contains x - do this, if contains y - so that, etc


=IFS(E2="Double Sided, A4",((ROUNDUP((F2/2)*G2)),""),(E2="Double Sided, A5/2 On 1pg",((ROUNDUP(F2/4)*G2)),""),(E2="Double Sided",((ROUNDUP(F2/2)*G2)),""),(E2="Single Sided",(G2*F2),""))

I'm pretty sure the above will satisfy what I need, although I get an error - hopefully a quick fix

Thanks for looking.

 

[Peter_SSs]

Looks like an identical question to post #7 in that existing thread.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.