im using this for a delivery formula
=IF(R3=2,"Delivered",IF(S3=2,"Not elivered",IF(R3+S3=3,"Delivered",IF(R3+S3=4,"Delivered",IF(R3+S3=5,"Delivered",IF(R3+S3=6,"Delivered",IF(R3+S3=7,"All Delivered","Check status")))))))
when it goes as far as if(r3+S3=2,Not delivered" thats as far as it goes the calculations are correct except it does not show delivered if r3+s3=4 it doesnt say delivered it says not delivered (There are no spaces in the formula this is just the way it came up when i pasted it here)
Bookmarks