|
Patch reliability is unclear, but widespread attacks make patching prudent. Go ahead and patch, but watch out for potential problems. |
Would someone be able to show me how to combine the formulas in F6 and G6?
The idea is to make sure that the quantity ordered is a multiple of the standard pack. Everything does work as it stands. However, I would like to have the formulas combined. Can this be done? If so, how?
Thanks!
On Edit: Never mind. I got it to work this time. Here’s what I came up with:
=IF(MOD($C6,VLOOKUP(Order!A6,PriceList!$A$1:$D$4,4))=0,”OK”,”Change Pack Qty”)
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
