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.
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.